Thread: VBA to send email (possibly containing HTML) to multiple contacts in Lotus Notes

I have a quite specific VBA request - I found how to do it on another website but I can't find it after hours of looking (I should have written it down I know) - what I need is:

VBA to send the same email to multiple addresses (they would be listed in a sheet, say from A1 to A500)

If possible I'd like it to send the message to one address at a time, but automatically, so click 'send' and it goes to the first address, then second, then third, etc..

I would like to be able to type the Subject and the content in cells on the same sheet as the addresses, possibly with some HTML in.

Is any/all of this possible?

Good afternoon diablodvs7

Originally Posted by diablodvs7

Is any/all of this possible?

Certainly is.

I have a file that will send the same e-mail to different people. The receipients are referenced in the file, as is the header, the mail body and the salutation. However, my file sends each recipient a different attachment, and sends them all at once but that wouldn't be difficult to fix. Just one line to suppress the attachment, and another line inserting, say, a MsgBox in the main loop would be easy enough.

Anyone wants this, just PM me your e-mail address and I'll foward you the file on Monday.

HTH

DominicB