What is the easiest way to send an e-mail to 2000 people listed in an excel sheet?

Question

I have an excel list of 2000 e-mails that I need to contact. I can copy and paste the e-mail column into the "To:" but would then have to insert a comma after each e-mail. What is the easiest way for me to send an e-mail to all 2000 people?

Answer 1

Better to use "mail merge" from ms word + Outlook.

or you can use OE instead of MS outlook

Select "mail merge" from tools. and apply this

refer this link http://word.mvps.org/faqs/MailMerge/Crea...

.

.

Answer 2

Some places let you do each person on a separate line (copy and pasting would work). Just a heads up: many ISPs will prevent you from sending mail to that many people to prevent spam.

Answer 3

Copy the contents of the excel doc into notepad. Select everything in notepad again and copy (this is so it wont copy any formatting).

Paste this into word. Open find and replace Ctrl-H.

By using the special characters button (at the bottom of find and replace) add paragraph.

Replace that with a "; "

Then replace all.. Once it's done, copy and paste that into the To: in outlook.

Answer 4

Excel formulas.

hopefully you can follow these steps:

- Assumptions: you have a list of email addresses like [e-mail] in cell A1, [e-mail] in cell A2 and so on (so you have a vertical list all in column A).

- Assumptions: you're sending this email to all 2000 people at the same time (as opposed to sending 2000 emails)

- cell A1 (change if your list is different) has the first name

- in Cell B1  put the formula        =A1

- in cell B2 put the formula         =B1&","&A2

- drag the formula in B2 down to your last address (YOU'RE NOT FINISHED YET!)

- the very last cell, do a copy and paste as value

-- copy (ctrl+c)

-- paste as value:  right click any cell you want and RIGHT CLICK then select "paste special..." then click the Value option.

there you go! you have all your emails in a comma separated list. you can copy that cell (or the contents) and paste into your email form

notes:

- there might be a limit on how much data you can fit in a cell, so you might have to do this in sections (like every 100 emails or something)

- as others said, there might be a limit on how many people you can send to at once

- I would recommend BCC the recipients so people don't get other people's email addresses