Using VBA to send personalized emails

[yrechtman]

Hi all,
Im trying to send emails from an excel spreadsheet. I have names and email addresses in columns A & B. I also have an embedded text box with a generic message. My end goal would be to create send each person and email reading"Dear Name," followed by the text from the text box.

I have run into two issues that I cannot figure out. The first issue is that although I can easily stick the text box in and email, I cannot figure out how to stick the name in before it. The second is that i can thus far only managed to send one email to everyone on the list which won't do. I need individual emails to go out to each (theoretically they will be personalized with names). I found some code online and it got me this far with some tooling around but I'm too new to VBA to figure it out beyond these issues. Thanks!

 

[Jerry Sullivan]

Hi and Welcome to MrExcel,

Ron de Bruin's website has many examples showing how to use VBA to send email messages for different scenarios.

The examples on this page are probably the closest to what you want....
Mail a message to each person in a range

When you say that you have a text box, do you mean an ActiveX or Forms Control? If so, which type?

 

[yrechtman]

Thanks, Jerry. I just figured it out. Ron de Bruin's site is really helpful!