VBA to Send Email Requests from Master List Array

[pkearney10]

Incredible! Exactly what I was looking for! Thank you so much!

[pkearney10]

Hi Kenneth

Is there a way to add my default signature to the macro? It's an HTML signature with a photo. I tried using .HTMLBody but when I do that the body text doesn't use my default fonts for some reason...

Thanks!

[Kenneth Hobson]

Use HTML to set your fonts. IF you don't know html, you could put your text into an Excel range and then use Ron de Bruin's RangeToHTML().
https://www.rondebruin.nl/win/s1/outlook/bmail2.htm

He has a routine to use the signature html file as well.
https://www.rondebruin.nl/win/s1/outlook/signature.htm

There are 2 other ways to insert the signature.