E-mail mail merge

  • Thread starter Thread starter Pepper
  • Start date Start date
P

Pepper

I have about 300 e-mail addresses in a column in Excel.
Is there a way to send one e-mail to all these people at one time?

Pepper
 
Use a mail merge starting from Outlook and use the Excel spreadsheet as your data source.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, Pepper asked:

| I have about 300 e-mail addresses in a column in Excel.
| Is there a way to send one e-mail to all these people at one time?
|
| Pepper
 
1 message with 300 recipients Sure - copy and paste the addresses in the To,
CC or BCC field. Because they are each on 1 line it'll work.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
Thank you Diane.
I couldnt figure out how to get a Merge Field into the To: line

Diane Poremsky said:
1 message with 300 recipients Sure - copy and paste the addresses in the To,
CC or BCC field. Because they are each on 1 line it'll work.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


Pepper said:
I have about 300 e-mail addresses in a column in Excel.
Is there a way to send one e-mail to all these people at one time?

Pepper
Click to expand...
Click to expand...
 
If you want to do an actual mail merge, 1 address per message, use the excel
book as the data source.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


Pepper said:
Thank you Diane.
I couldnt figure out how to get a Merge Field into the To: line

Diane Poremsky said:
1 message with 300 recipients Sure - copy and paste the addresses in the
To,
CC or BCC field. Because they are each on 1 line it'll work.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Pepper said:
I have about 300 e-mail addresses in a column in Excel.
Is there a way to send one e-mail to all these people at one time?

Pepper
Click to expand...
Click to expand...
Click to expand...
 
Back
Top