1st I'd like to apologize in advance if someone has already requested this help and it has been solved. I've peered through the forum for a bit and couldn't find exactly what I was looking for.
I have the following table in excel:
What I'm trying to accomplish is to have excel/vba send an individual email to the address listed in column n for each email address. So based off of the table above, once I run the macro outlook would send 6 separate emails to the following addresses: js@acme.com, sm@acme.com, ma@acme.com, etc. I'd like the subject to be "Request Type:" + the value listed in column M and the body to be "Dear " + value listed in column E, skip two lines and have the rest of the body read: "Your request has been " + the value listed in column O.
after each email has been sent I'd like to have the line removed from the table if possible. Any/all help that can be provided would be very much greatly appreciated, thank you in advance.
Regards,
Cody
I have the following table in excel:
What I'm trying to accomplish is to have excel/vba send an individual email to the address listed in column n for each email address. So based off of the table above, once I run the macro outlook would send 6 separate emails to the following addresses: js@acme.com, sm@acme.com, ma@acme.com, etc. I'd like the subject to be "Request Type:" + the value listed in column M and the body to be "Dear " + value listed in column E, skip two lines and have the rest of the body read: "Your request has been " + the value listed in column O.
after each email has been sent I'd like to have the line removed from the table if possible. Any/all help that can be provided would be very much greatly appreciated, thank you in advance.
Regards,
Cody