C
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
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