EmailMerge - more than one address in the email field creates erro

J

Jane

In my email merge my data source has a field I create from three different
email fields - if the record has a value in email1, add it to (e-mail address removed)
 
B

Beth Melton

You can use multiple email addresses in a regular email but it appears Word
is treating the entire field as one email address. This makes sense because
the nature of using mail merge and email is to send individual emails.

If you need to send to all of the email addresses then you may need to
perform three separate merges to accommodate each email address. For the
second merge use Email2 but also add a filter using the "is not blank"
criteria on the field. That way an email will only be send to those who have
data in Email2 and the same would apply for Email3.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top