Connecting Tech Pros Worldwide Help | Site Map

Reporting - export to MSWord doc.

Robert
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Keith Wilby
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Reporting - export to MSWord doc.


Rparker@gmx.de (Robert) wrote:
[color=blue]
> 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
>[/color]

Hi Robert,

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

HTH - Keith.
www.keithwilby.org.uk
Pieter Linden
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Reporting - export to MSWord doc.


Rparker@gmx.de (Robert) wrote in message news:<b605fed4.0311210359.35db0897@posting.google. com>...[color=blue]
> 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[/color]

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.
Albert D. Kallal
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Reporting - export to MSWord doc.


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
NoooSPAmkallal@msn.com
http://www.attcanada.net/~kallal.msn



Pieter Linden
Guest
 
Posts: n/a
#5: Nov 12 '05

re: Reporting - export to MSWord doc.


"Albert D. Kallal" <pleasenonosspammkallal@msn.com> wrote in message news:<XbAvb.452994$pl3.352500@pd7tw3no>...[color=blue]
> 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[/color]

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...
Closed Thread