Multiple address mail merge problems

D

Donn

I'm able to email merge from Word (which uses an Excel file as the data
source) to Entourage, but if I have multiple email addresses in one
field separated by commas, they are imported to Entourage with <> on
either side, i.e., <[email protected], [email protected]>

Entourage doesn't break this into two separate addresses but tries to
send it as one, and comes back with the message "The message could not
be sent because it has unresolved recipients". To solve this glitch, I
have to go into each of the 'faulty' messages and separate the
addresses individually.

Any ideas how to fix the problem? It takes me hours to do it by hand.

Thanks.

Donn
 
H

Hat

Donn said:
I'm able to email merge from Word (which uses an Excel file as the data
source) to Entourage, but if I have multiple email addresses in one
field separated by commas, they are imported to Entourage with <> on
either side, i.e., <[email protected], [email protected]>

Entourage doesn't break this into two separate addresses but tries to
send it as one, and comes back with the message "The message could not
be sent because it has unresolved recipients". To solve this glitch, I
have to go into each of the 'faulty' messages and separate the
addresses individually.

Any ideas how to fix the problem? It takes me hours to do it by hand.

Thanks.

Donn
Click to expand...

Donn: I looked in the Entourage preferences and couldn't find what I
was looking for; Outlook had a setting where you could change multiple
address entries to be separated by commas instead of semi-colons (oh
Well...). Anyway, before you merge, go into the Excel file, do a search
and replace on the colum that contains the email addresses, and replace
all "commas" with "semi-colons". THEN, co your merge and everything
should come out OK.

Hat
 
D

Donn

Donn said:
Donn: I looked in the Entourage preferences and couldn't find what I
was looking for; Outlook had a setting where you could change multiple
address entries to be separated by commas instead of semi-colons (oh
Well...). Anyway, before you merge, go into the Excel file, do a search
and replace on the colum that contains the email addresses, and replace
all "commas" with "semi-colons". THEN, co your merge and everything
should come out OK.

Hat
Click to expand...

Thanks for the idea Hat, but it doesn't work.

I'm able to do the find and replace, but when Entourage imports the new
addresses, it still puts the <> as leading and ending markers around
the multiple addresses. This is what's causing the problem, and so it
again gives me the "unresolved recipients" message.

I continued looking last night at preferences, help systems, and
experimenting with different symbols, but I'm still not able to get
away from either the <> on multiple addresses, or a way to import the
addresses as separate entities that carry along the related fields.

I used to use a program named "email merge" which didn't encounter this
problem when creating multiple email messages, but I don't believe it
works with any of the Mac's System X iterations.
 
P

Paul Berkowitz

Thanks for the idea Hat, but it doesn't work.

I'm able to do the find and replace, but when Entourage imports the new
addresses, it still puts the <> as leading and ending markers around
the multiple addresses. This is what's causing the problem, and so it
again gives me the "unresolved recipients" message.

I continued looking last night at preferences, help systems, and
experimenting with different symbols, but I'm still not able to get
away from either the <> on multiple addresses, or a way to import the
addresses as separate entities that carry along the related fields.

I used to use a program named "email merge" which didn't encounter this
problem when creating multiple email messages, but I don't believe it
works with any of the Mac's System X iterations.
Click to expand...

The Email field used for email merge in a Word or Excel document can only
have one email address. In your Excel worksheet you'll need to remove the
extra email addresses. If you need the merge to go to those addresses too,
you'll need to make new entries (rows) in Excel, otherwise just remove them
- or if you need them to be recorded for some reason, make new columns for
Email2, Email3, etc. which will not be interpreted as the sending address
since they're not called simply "Email" field (column).

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
Top