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!

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!

Thanks for the reply. I forgot to mention that I am not using outlook and
do not have it installed. I am using Thunderbird if that is of any help.
I can provide SMTP server and SMTP login info to the macro.

On Thu, 9 Aug 2007 06:10:01 -0700, John Bundy (remove)
wrote:

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

Test the SendMail examples first on my site (first section)
http://www.rondebruin.nl/sendmail.htm

If this is not working try the CDO code
http://www.rondebruin.nl/cdo.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
Thanks for the reply. I forgot to mention that I am not using outlook and
do not have it installed. I am using Thunderbird if that is of any help.
I can provide SMTP server and SMTP login info to the macro.

On Thu, 9 Aug 2007 06:10:01 -0700, John Bundy (remove)
wrote:

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