E-mail mail merge

[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

 

[Milly Staples [MVP - Outlook]]

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

 

[Diane Poremsky [MVP]]

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]



Outlook Tips by email:
(e-mail address removed)

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]

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

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]



Outlook Tips by email:
(e-mail address removed)

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.

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

 

[Diane Poremsky [MVP]]

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]



Outlook Tips by email:
(e-mail address removed)

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

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]



Outlook Tips by email:
(e-mail address removed)

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.

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