Combine data for Mail Merge

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I have a database with several related tables. The main
table has one entry for each property and there are four
related tables that have unlimited records for each
property, for example a list of structures on the
property is in one, a list of tanks on the property is in
another, etc.

I need to create a mail merge to a word document (approx
25 pages long) one document per property. I need to
COMBINE all the structures into a single field possibly
separated by commas to merge into the document; and
COMBINE all the tanks into a single field possibly
separated by commas to merge into the document, etc.

Is there a way to do this using a macro? I'm thinking of
making a temp table to dump the data into for the merge.
I don't know how to cycle through all related records for
a specific piece of property until I get to the end to
copy and append them to the end of that field in my temp
table. Would it be better to use VBA?

Any ideas would be appreciated!!
Thanks!!
 
You might want to investigate XpertDoc as an alternative to Word Mail
Merge. It is a very flexible document generator technology that
outputs a genuine MS-Word document. What you are trying to do would be
very easy to achieve using it.

You can check it out at www.xpertdoc.com. The support staff will be
more than happy to help you with any questions you might have.

Regards,
 
Back
Top