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 field,
if the record has a value in email2, add it to [email] field, etc. The
emails are separated w/ semicolons.

In my mailmerge, I enter the [email] field in the Merge to Email Dialog box.
If there is more than one address in the [email] field I get the following
message:


Microsoft Office Outlook does not recognize '[email protected]; [email protected]'

Select the address to use
(box w/ no selections)

We're running Exchange server and Microsoft Office 2003, SP2.

It was my understanding that I could have multiple addresses in my email
field.
 
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/
 
Top