Send an email via macro with dynamic recipient address

Hi All,

I am attempting to automate a loooong process in which I have to send 100s of emails to individual recipients.

Is there a way to automate an email to a list of recipients BUT only send to one recipient at a time? Here is an example of what I am attempting to do (attached and screenshot):

Try this code, but take it from the attachment since the HTML in the code has added spaces so the code can post.

Please Login or Register  to view this content.

_______________________________________________________________



Absolutely perfect! Thank you.

I should have asked in my original question, but what if I want to embed a picture. Here (attached) is what I was using previously without dynamic emails. Is there any way I can add this to your code? I tried to add it in the body but was unsuccessful.

Nevermind, I was over complicating it and had a page break that was screwing it up.

Thank you Maniacb for your help!

For ref, below email body text i inserted the file path for the file I wanted to embed.