Hi All,
I have found a few VBA scripts online to send an email from excel, however I ran into some problems. The script I have doesn't include text in the subject line of the email. I also would like to choose who the email is being sent to by writing their email address in A1. Is anyone able to write a script to do this?
Key things to include:
I want the email to be sent to the email addresses in column A1:A10
I want the cc to be the email addresses in column B1:B10
I would like the subject of the email to be the text from C2
I would like the body of the email to include whatever is in D:D
I am almost positive this is possible, but I can't find the exact criteria with a google search.
Thanks
Bookmarks