View Single Post
  #6  
Old December 13th, 2004, 07:09 AM
Jason Krug
external usenet poster
 
Posts: n/a
Default

Mark, Graham-

Is there an answer to this question? I too have the same issue.

In my mailmerge, my 'To' field will have single or multiple email addresses.
eg1:
eg2:
;

Some projects have multiple contacts, AND I want to copy the message to
myself (for records). Since Mailmerge only allows you to select 1 field for
TO:, I combined the addresses into one field.

However, Word's MailMerge puts ""s (double-quotes) around the addresses, so
the value becomes
;
". When sending the
emails, Outlook tries to lookup the contacts in the Addressbook, and tries to
lookup this value as 1 contact, not as separate email addresses.

I am using Office 2003. I have word Office 2003 connecting to a ODBC
datasource, which is an Access 2003 Query.

Help!
--Jason

PS: I have thought about using Access to break out the distribution list,
create multiple records (each with 1 email address), but then the To: list
would not reflect the people that this message was sent to.


"Mark V" wrote:

Is there a way to send a single email message to multiple recipients
simultaneously so that all of these recipients appear in the "To:" field for
this message rather than sending the message separately to each individual?
This would be useful when send email to a group of owners for a certain
product, project or service as opposed to sending individual messages to each
or for sending a message to a specific individual and their manager or
administrative assistant.

I have tried creating a Mail Merge field consisting of several email
addresses (comma-delimited and semicolon-delimited lists of SMTP addresses or
Outlook Address Book Display Names) and selecting this field as the "To:"
field in the Merge to E-mail Message Options but it doesn't work.

Summary of results:

- Using comma-delimited SMTP email addresses results in a Check Names error
messsage which indicates that Outlook doesn't recognize the comma-delimited
SMTP email addresses and suggests replacing the commas with semicolons.

- Using semicolon-delimited SMTP email addresses results in a Check Names
error messsage which indicates that Outlook doesn't recognize the
semilcolon-delimited SMTP email addresses.

- Using semicolon-delimited Display Names from the Outlook Address Book
(Personal or Global) results in a Check Names error messsage which indicates
that Outlook doesn't recognize the semilcolon-delimited SMTP email addresses.

I am using Microsoft Office Word 2003 (11.5604.5703) and Microsoft Office
Outlook 2003 (11.5608.5703) from Microsoft Office Professional Edition 2003.

Any guidance is appreciated.

Thanks, Mark V