Mail merge into Word Doc

R

rfrench

I am having trouble figuring out how to choose which record in Access is
merged into a mail merge Word doc. I have multiple Forms or Tables that I
want the information to come from. Do I have to create a Query? How do I
easily tell the document which record to choose? Thanks!
 
A

Albert D.Kallal

If you can build a query, and the data that comes from multiple tables
results in ONE record of data to merge, then use my mail merge example here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

The above is designed to work in your application, and merge the ONE record
you a viewing to word.

Give the sample above a try, as it has some data built in. If it seems good,
then use the step by step instructions on how to use the above in YOUR
application;

however, if your merge to the one word document needs more then ONE record
to go into ONE word document (ie repeating data from those tables has to go
into ONE word document, then you got a complex problem that requites lots of
coding.

So, you can easily send the results of several tables into a word document
IF YOU can build a query that returns one row that is comprised of the many
tables of data. Building this query is very easy, and my word merge will
handle that without problem.
 
Top