Access mail merge to word, multiple sources

  • Thread starter Thread starter crealesmith
  • Start date Start date
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
 
use reporting services for mail merge

using word and access mdb is for first-graders

reporting services scales

I just wrote a couple of hundred 'mail merge' reports using Reporting
Services

-Aaron
 
I don't know the answer to your question, but I thought I'd
post and recommend that you ignore aaron; he's just messing with you.
Robin S.
 
your boss doesn't understand that

a) word isn't a reporting platform
b) MDB isn't a reasonable database

lose the training wheels and learn SQL Server

I just wrote abotu 50 mail merges in reporting services in a period of
about 2 months; but now that I'm up to speed it would probably take me
less time to do it in RS than it would take you do it in Word.

If you want to do a mail merge from 3 data sources, use SQL Server
Reporting Services.

-Aaron
 
If nobody here can help you, try posting to the Office
programming newsgroup(s).

Robin S.
-------------------
 
don't listen to this dyke; im correct

if you want to mail merge in the year 2007; then just use Reporting
Services

-Aaron
 
Back
Top