Auto Email

[Chad]

Hello, I was woundering if this is possible and if so how. I want to "Auto
send" an email to 4 people once a month and in this email it would include
the information from two sheets from my workbook. The first sheet is named
"Years Of Service" and in the email I need to include the info in cells B22
down to B2020. Then from my second sheet named "Birthdays" I need the email
to include info from cells B2:C2 down to B20:C20.

Thanks,
Chad

 

[Gord Dibben]

For all Excel email questions get answers at Ron de Bruin's site.

Note the SendMail add-in available as well as the code.

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


Gord Dibben MS Excel MVP