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