|
|
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
|