[Sfmuziq]

Hello: I have a mail merge that works fine when merging to a new document.
The merge is a one-to-many merge so there are two tables that are linked to
an external database table. The rest of the merge is linked to an excel
sheet. When merging to a new document and clicking edit individual letters,
the tables are updated to show the information for correct information for
the current record. However, when merging to email, the tables in each word
document do not update and show the information only for the 1st record. Is
there a way to force the tables to update and then send the email?

Thanks,

Jeff

[Doug Robbins - Word MVP]

A work around would be to use code similar to that in the article "Mail
Merge to E-mail with Attachments" at:

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

If you are trying to get the merge to email the documents as attachments,
you could create individual documents for each record by using the add-in
that you can down load from:

http://www.gmayor.com/individual_merge_letters.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Sfmuziq" wrote in message
...
Hello: I have a mail merge that works fine when merging to a new
document.
The merge is a one-to-many merge so there are two tables that are linked
to
an external database table. The rest of the merge is linked to an excel
sheet. When merging to a new document and clicking edit individual
letters,
the tables are updated to show the information for correct information for
the current record. However, when merging to email, the tables in each
word
document do not update and show the information only for the 1st record.
Is
there a way to force the tables to update and then send the email?

Thanks,

Jeff