Send an email from Excel VBA

[Guest]

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!

 

[Guest]

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

 

[Guest]

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.

 

[Ron de Bruin]

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