E-mailing parts of an excel worksheet

[Fern]

I have a 3,000 line worksheet with several columns with different e-mail
addresses. E-mails are repeated several times. I would like to be able to
automate e-mailing the information on the lines that pertains to the e-mail
address.

Example

email address name Marital status
Sex
(e-mail address removed) John Doe S M
(e-mail address removed) Betsy Smith S F
(e-mail address removed) Billy Jones M
M

 

[Gord Dibben]

All you ever need to know about emailing from Excel can be found at Ron de
Bruin's site.

http://www.rondebruin.nl/sendmail.htm

Note the free Sendmail Add-in to make your life easier.


Gord Dibben MS Excel MVP