This should have everything you need (for this and about everything else)
http://www.rondebruin.nl/mail/folder3/mail4.htm

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

Is there a way to send an email from VBA in Excel? I need to control the
contents of the body, and the To:, From:, and Subject: headers. The email
does not need to have any attachments.

Background: I administer several email lists. Some folks are members of
multiple lists. I keep a data base of list members in Excel. When someone
changes their email address I now enter the change into a form and VBA
updates the d6tabase. I would like for VBA to send the appropriate emails
to change the address on each list server.

Many thanks for any help!