Mail Merge Access with Word

[dah]

Hi,

I have created a database that seems to work ok now. Been a real learning experience. I now need to take information from the database and do a mail merge into Word. I have done mail merges with Excel before but not Access.

I have a form designed that shows participant information and then lists all the workshops they have attended in a subform. This works fine. I can also run a report that lists the participant's name and all the workshops they have attended. No problem.

My participant table lists each participant individually (by autonumber) and then the workshop table lists each workshop. They are joined by another table that has the participant ID (primary) key and workshop ID (primary) key. I ran a query that had the participants name, workshop and date. What I get is a long list of participants and their workshops. For example:

Tom Jones attended 5 workshops - he is listed in the query five times. This doesn't bother me except that if I use this query for the mail merge (I guess I can't use the form or report) I get five separate letters for Tom Jones. What I need is one letter that lists all the workshops for Tom Jones.

Such as:

Dear Tom Jones:

Thank you for attending the following workshops:

1
2
3
4
5

ect, ect.

Some people have only attended 1 workshop but others have attended 10 or more.

How can I do this mail merge or are my tables set up wrong?

Thanks,

 

[IMO]

There's an example here that may help you get started

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40119&highlight=mailmerge

IMO

 

[dah]

Hi,

I looked over the examples you sent but it still does not answer my question. I can do the mail merge fine except that I only get one row of information per person. I tried creating the report and then copied the info into Excel. Again, if one person attended more than 1 workshop I get multiple letters.

There has got to be a way. I made a form in which access looks up informtion in other tables so why can't information be combined for the mail merge?

 

[Thicklizzie]

Create a Report that is structured like a letter and you will be able to get multiple information for 1 record.

If you use the Report writer to create a label or envelope you will be able to print only 1 envelope for each record.

There is a Report writer wizard that will help you get started and typing questions into the help section box got alot of useful information.

 

[GaryPanic]

why use word - use te reports in access forthis ..if needs be you can dump a single report in to a rtf file