Connecting Tech Pros Worldwide Help | Site Map

Reporting - export to MSWord doc.

  #1  
Old November 12th, 2005, 04:44 PM
Robert
Guest
 
Posts: n/a
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
  #2  
Old November 12th, 2005, 04:44 PM
Keith Wilby
Guest
 
Posts: n/a

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
  #3  
Old November 12th, 2005, 04:45 PM
Pieter Linden
Guest
 
Posts: n/a

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.
  #4  
Old November 12th, 2005, 04:46 PM
Albert D. Kallal
Guest
 
Posts: n/a

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



  #5  
Old November 12th, 2005, 04:47 PM
Pieter Linden
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Handling Multiple File Uploads into Database with single INSERT INTO??? jenkinsloveschicken answers 6 January 17th, 2008 10:06 PM
convert HTML string into csv/xls/doc >>Shailesh answers 7 September 30th, 2005 11:21 AM
Problem with converting HTML to Word/Excel/Etc. Phil Powell answers 2 July 17th, 2005 01:38 AM