Send email as To address to all email id stored in excel

Hi

i have an excel file having as per below

Name email id
=================
AAA [email protected]
BBB [email protected]
CCC [email protected]
DDD [email protected]

My requirement is if i open the outlook and after typing the matter and press send button i want to send the same email to all the address separately which is the excel file and the address should be in To address .

The name also should display at the beginning of the email content

ie Dear AAAA or Hi AAAA

<Content>

is it possible to do ie to send email to bulk of employees

I send many emails separately by doing this, I simply copy the addresses from excel and paste them into the BCC address bar, this way each player (player in my case; employer in your case)gets the same email. I think outlook has a maximum of 100 or120 addresses. Gmail is a lot higher; I'll send out to 250 or more email addresses with the one letter.
Getting the name in the start, well sorry in can't help with that.
Peter

Try this code. This is assuming you have names in column A and email addresses in column B.

Please Login or Register  to view this content.

Hi all,

Where i have to write the body and subject.
can you attach a sample excel file.

Thank you

Hi,

Thank you , its working,

More queries

1. is it possible that if i write all the body part in outlook 2013 and send emails from the excel list.
2. if my outlook 2013 is having 3 email ,how can i select the email id for sender.

Thank You