Excel macro that will send emails from outlook

**terreese** · 02-13-2014, 11:24 AM

Hello guys! I got this VBA code from a colleague which he uses when sending multiple emails from Outlook. I don't have a programming background and I would like to ask for help on how to modify it. This code sends email based from the last cell. What I would like to do is send emails to all the recipients listed in column C. Column A will be the sender and column B will be email subject. Attached is the sample file.

Please Login or Register  to view this content.

**AB33** · 02-13-2014, 11:46 AM

This sends to all cells in column C, though my knowledge with e-mail is almost zero.

Please Login or Register  to view this content.

**terreese** · 02-13-2014, 11:57 AM

Hi AB33! I was using the template with the updated VBA code but I noticed that all emails have the same subject (from column B). How can I modify the code to ensure that the email subject will be what is listed in column B? Also, if possible, change the sender to what is in column A? Thanks!