email with corresponding addresses and names in body AND subject using gmail

[excel4phil]

Hello everyone,

I did search for this, but couldn't find the exact answer.

I use gmail, and have an excel sheet with hundreds of rows. I need to send each recepient an e-mail using their e-mail address (row D), and their name in the body and subject (row A). The rest of the body of the email will all be the same.

Thanks!

[Richard Buttrey]

Hi,

Take a look at the following thread.
http://www.excelforum.com/excel-prog...-formulas.html

You'll just need to modify the code with a loop that uses the loop variable to identify the position of an email address in a list and read that value into the .To instruction in the code.

HTH

[excel4phil]

I'm sorry, I guess Im a little noob here, but I don't even know where to insert that code or what a loop is, or how to change the name in the e-mail that starts with "Dear <name>, .... "

[Leith Ross]

Hello 4thephil,

Can you post the workbook? We can then add the macro into the workbook for you.

Sincerely,
Leith Ross

[excel4phil]

I can't post the entire workbook as it is private. So, I copied and pasted the first couple of rows and changed the data, and created a new workbook. Hope this works the same? Thanks for your help!

[Leith Ross]

Hello 4thephil,

I have added the macro below to the attached workbook. There is button on Sheet1 to run the macro. The draw back to sending out multiple emails is security. You will have to send each email as the macro cycles through. If I wrote the macro to use Outlook, you would be barraged by annoying dialogs with time delays. Since this is a simple text only email, It would easier and faster to use CDO (Collaboration Data Objects) to send the emails with no annoying messages. The down side of CDO is it more complex and harder to understand. I felt this code would be a good starting point.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[excel4phil]

Wow, thank you so much for taking the time to do this. I loaded that up and clicked the button, and it immediately launched gmail with the e-mails pre-filled out. I will play around with this and tailor it to exactly what I need, but yes, this will work perfectly. Thank you for taking the time to do that! *Very impressed*

[mfaisalrazzak]

HI

its possible change Sudject in everty mail with attachemnet.

[HaHoBe]

Hi, mfaisalrazzak,

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Ciao,
Holger