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

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

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.

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

"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...