Query and Mail Merge

[Guest]

Help needed please

I have a database which im trying to run a query and merge the data to a
Word document - but the mail merge is not working.....it appears to not like
the query.
It will merge the standard table but not a query???

Any idea's?

Thanks

 

[Guest]

You might like to take a look at the demo of various Access to Word
automation routines which I've posted at:


http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


The mail merge operations in the demo file work by transparently creating a
delimited text file which is used as the data source for the merge rather
than using the query directly. I've found this gives better performance, and
should overcome the problem you are encountering as the origin of the text
file is completely irrelevant as far as Word is concerned.

Ken Sheridan
Stafford, England

 

[aaron.kempf]

we use SQL Server Reporting Services for mail merge.. it works GREAT; I
love it.

I reccomend using Access Data Projects for data entry / simple
reporting and definitely use SQL Server Reporting Services for
mail-merge / complex reports... or OWC / Analysis for complex
multi-dimensional adhoc reporting.

-Aaron