Send mass email with outlook

Is there anyway to send a mass email through outlook? I have the names and emails on an excel sheet. I would like each recipient to receive an email that is only addressed to them. Also, have their name in the first line. So it says "Dear Bob,"

Any way to make this happen?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Have you look into Mail Merge

Open an Excel worksheet
In Columns A type first name
In Column B type last name
In Column C type email address

On the tab rename it Recipient List
Save the Excel Document

Now open Word
Click on the "Mailings" tab
Click on Select Recipients drop down
Select "Use Existing List....."
Browse to the location you save the Excel Document
Click Open
The "Select Table" box opens
Note: We name the Sheet 1 "RecipientList"
Select it and click OK

Now you can Write on the Word document

Like "Dear"
Now from the "Mailings" tab click on "Insert Merge Field" drop down list
You able to select the First, Last , or email address
Example if done correctly you will see
Dear <<First>>
Now click on "Preview Results" still on the "Mailings" tab you can now scroll through to see the names that were added in the document.

If you are finished you can click on "Finish & Merge" drop down list
Select "Send E-mail messages...."

The TO: field should have "Email"
Now write a subject line
Mail Format you can select an item of your choose, but HTML is default
Click okay an you are done.

Here is a link for more information and pictures

I hope this helps

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cansevinAuthor Commented:
Thanks! I'll check that out.

Any limit to the number it will send? Can it send 500? Thanks!
You might get an error message when sending a message to multiple users, Outlook reports “too many recipients”. This error is not given by Outlook but by your ISP or corporate mail administrator. ISPs or corporate mail administrators usually have one of the following limits set or a combination of them;

amount of recipients for a single email
amount of emails that you can send in an hour
amount of emails that you can send in a day

These limits are set to protect their mail server from excessive use or even abuse by spammers. You’ll have to contact your ISP or corporate mail administrator to find out which exact email policies they have in place.
cansevinAuthor Commented:
Thanks! It worked. I appreciate your help!
No problem anytime

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.