VBA: Creating Multiple E-Mails from E-Mail List

[AZJ]

Hello,

While I believe this may be possible, and I've done this in earlier versions of Excel (but lost my code), but it doesn't appear to be working in 365. I've referenced https://www.rondebruin.nl/win/s1/outlook/bmail5.htm, however it doesn't really seem to do anything

What I am trying to do is create multiple e-mails for each name / e-mail address listed in an excel spreadsheet with a common subject, body / my email signature.

So, for instance, Cell A2 contains a name 'Jim', and cell B2 contains JIm's e-mail address 'jim@bob.com', I would like a macro to loop column A & B, and create an individual e-mail with a common subject & body, but individualized with a name.

So in Jim's case, the e-mail would look like

To: jim@bob.com
Subject: Important Stuff
Body:

Hi Jim,

This is important Stuff.

Sincerely,

AZJ

Then, the macro would reference cell A3 & B3, and create an individual e-mail for a following name / e-mail address entry, so on and so forth.

Any assistance / insight is greatly appreciated.

Thank you,

AZJ