Merge multiple records to single Word doc (office 2003 pro)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I have inherited a merge routine at the moment which creates one word letter
per dealer in a query in Access.

My task is to modify this to include a table at the bottom of each letter
containing five rows of data per dealer also from Access. I have a seperate
query which has the relevant data but I am not sure how to merge multiple
records per dealer into the one letter per dealer?

Hope this makes sense, can any one help?

Thanks
Sue
 
I would suspect this to be similar to creating labels in Word, you have
multiple records on one sheet (one per label). You would set up a 5 row
table, one row for each record you want reported, and include the desired
fields in each row. There is a command that you can include in the table
telling Word to get the next record. The code for the command is «Next
Record».

The folks in the Word newsgroups can probably help you better with setting
this up.
 
Thanks, ended up doing it all in Access instead and changing it to a grouped
report. Mail merge with word doesn't really seem to be designed for this type
of recordset, at least not very easily!
 
Back
Top