Mail Merge: multiple recipients on To: line?

M

Milly Staples [MVP - Outlook]

Mail merges are intended to send the same item to multiple recipients with only one receipient per item. What are you actually trying to do? And in what version of Office? Are you trying to start the merge from Word or Outlook?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Kennard asked:

| How can a single emails be sent to multiple email adresses using mail
| merge with Excel as the datasource?
|
| E.g.
| Excel cell entry: "[email protected];[email protected];[email protected]"
| Email contains an mail merge field that applies to all three desired
| recipients.
|
| Thanks.
 
K

Kennard

Outlook 2003
Starting merge from Outlook.

I want multiple recipients per item.

The datasource is an Excel workbook.
Each row has one cell called "title" and another cell called "names".
The "names" cell contains several email addresses, separated by a semicolon:
Title Names
Database billb;wallyf;maryt
Machine bobg;peterl;kimb

I want each merged email to contain all email addresses in the To: line.
Merged email #1 has "Database" in the body and billb;wallyf;maryt in the To:
line.
Merged email #2 has "Machine: in the body and bobg;peterl;jimb in the To:
line.
 
Top