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

On Wed, 17 Mar 2010 14:32:01 -0700, Fern
wrote:

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
John Doe S M
Betsy Smith S F
Billy Jones M
M