Access mail merge to word, multiple sources

[crealesmith]

Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source that

is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.

Is there anyway of looping through the 3 selected records and inserting

them into a temporary table that can then be used as the source of the
mail merge?


Are there any other methods that can be used to create the page with
all the data together. I have tried creating a report to display the
data, which works perfectly until it is exported to Word and then
decides to display all the data in a different layout!


I apologise if this is very vague, I will try and be more detailed to
any questions or comments posted.


Many thanks

 

[Albert D. Kallal]

There are samples and ideas on how to do this at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

look on the left side for speical merges. The one you want is

Multiple items per condition

 

[Chris]

thanks for your help guys.
Will have a go when i'm back in work tomorrow.