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

**diablodvs7** · 04-12-2008, 10:06 AM

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?

**dominicb** · 04-12-2008, 10:20 AM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions