Mail merge into Word Doc

[Guest]

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!

 

[Joseph Meehan]

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!

You can make a query using the wizard. With a select query you can
tell it what record or records you want to display and any merge using that
query will include only those records.

Detailed instructions for everything you ask is a bit much for a
newsgroup.

I suggest you spend a little time with Northwind, the example database
that comes with Access and maybe find a basic Access how to book.

Access is not easy to learn, especially at the beginning, but it is a
very useful program once you get to know it.

 

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