469,600 Members | 2,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

Reporting - export to MSWord doc.

Hello,

I would like to take the data from a query and export it to an MSWord
doc or dot that can display the fields. (Auto fill)

I have been trying to figure out how to do this, but have not found
the appropriate documentation as to how to set this up.

Can someone help me out here.

Regards,

Robert
Nov 12 '05 #1
4 1776
Rp*****@gmx.de (Robert) wrote:
Hello,

I would like to take the data from a query and export it to an MSWord
doc or dot that can display the fields. (Auto fill)

I have been trying to figure out how to do this, but have not found
the appropriate documentation as to how to set this up.

Can someone help me out here.

Regards,

Robert


Hi Robert,

The process to use is "Mail Merge". Search the help on either 'mail' or
'merge'.

HTH - Keith.
www.keithwilby.org.uk
Nov 12 '05 #2
Rp*****@gmx.de (Robert) wrote in message news:<b6**************************@posting.google. com>...
Hello,

I would like to take the data from a query and export it to an MSWord
doc or dot that can display the fields. (Auto fill)

I have been trying to figure out how to do this, but have not found
the appropriate documentation as to how to set this up.

Can someone help me out here.

Regards,

Robert


Open a recordset based on the query, open Word through automation, and
then pass the recordset to Word and build the table there. Covered in
the Developer Handbook in the Automation chapter.
Nov 12 '05 #3
I have a working download that does exaclity this.

Grab it, and give it a try. Also read the info on how it works.

Check out my super easy word merge at::

http://www.attcanada.net/~kallal.msn.../msaccess.html

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #4
"Albert D. Kallal" <pl********************@msn.com> wrote in message news:<XbAvb.452994$pl3.352500@pd7tw3no>...
I have a working download that does exaclity this.

Grab it, and give it a try. Also read the info on how it works.

Check out my super easy word merge at::

http://www.attcanada.net/~kallal.msn.../msaccess.html


Albert,
I guess I was thinking that if you want to do a complex mail merge
(1-M) data, then you'd have to use the stuff from ADH. Otherwise,
yours is easier...
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by David | last post: by
reply views Thread by Tom Gao | last post: by
4 posts views Thread by TRobran | last post: by
1 post views Thread by Cloud | last post: by
8 posts views Thread by Ibrahim. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.