Mail Merge

[database]

Hi everyone,

Can anyone help me with grouping data in mail merge in word?
I have been trying to group data in word... I have data like this

First name:Tom C
Topics: A
B
C
D


I have a qry in access, Select FirstName, Topics from tblInfo.

This qry gives me the FirstName "Tom" 4 times since there are 4 topics. Grouping also doesnt help here.. I think I have to group it here but can anyone tell me how so that I get one first name and 4 different topics.

Or in word when i do mail merge, how do i have one name and below that name, all the topics one after another...the way it can be done in access reports.

Any help is appreciated.

Thanks
dB

 

[Mike375]

dB,

I don't knows if this will be of any help but this is what we do. I am in the insurance business so a client is your "Tom" and Topics A, B. C etc are policy benefits.

Sometimes I do the mail merge through Office Links to the client and so his name, address etc are inserted and followed by the contents of the letter. For the policy benefits I print those from a form and we attach them to the letter. This works quite well for us because the listing of policy benefits and some notes at the top of the page make it look just right.

The other thing I do is to insert the client data into Word Bookmarks and the document has a query with the policy benefits linked to it. For the query criteria I use [Forms]![MyForm]![ID]. In this case I open a form and it might display 50 records. The word doc is opened and the entries made to the Word Bookmarks and then the doc is printed and closed. Access then moves to the next record and repeats the proces. I base this on the OnTimer event and set the time so it is just a bit slower than the speed of the printer. This is handy if paper or evenlope jams occur. The negative with this system is that you could not do a run of hundreds as the computer would freeze up as it ran of memory. Mostly I use this system and if bigger runs are needed then I just reboot the computer and start the next run. The Bookmarks for me give much more flexibilty than the Mail Merge.

Perhaps someone will have a much better sway and we can both gain

Mike

 

[database]

dB,

I don't knows if this will be of any help but this is what we do. I am in the insurance business so a client is your "Tom" and Topics A, B. C etc are policy benefits.

Sometimes I do the mail merge through Office Links to the client and so his name, address etc are inserted and followed by the contents of the letter. For the policy benefits I print those from a form and we attach them to the letter. This works quite well for us because the listing of policy benefits and some notes at the top of the page make it look just right.

The other thing I do is to insert the client data into Word Bookmarks and the document has a query with the policy benefits linked to it. For the query criteria I use [Forms]![MyForm]![ID]. In this case I open a form and it might display 50 records. The word doc is opened and the entries made to the Word Bookmarks and then the doc is printed and closed. Access then moves to the next record and repeats the proces. I base this on the OnTimer event and set the time so it is just a bit slower than the speed of the printer. This is handy if paper or evenlope jams occur. The negative with this system is that you could not do a run of hundreds as the computer would freeze up as it ran of memory. Mostly I use this system and if bigger runs are needed then I just reboot the computer and start the next run. The Bookmarks for me give much more flexibilty than the Mail Merge.

Perhaps someone will have a much better sway and we can both gain

Mike

Thanks Mike. But I think I am still confused !!!!!!! Can you exaplin it to me again ???