View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] NoSpam@aol.com is offline
external usenet poster
 
Posts: 142
Default Send an email from Excel VBA

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!