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 B2:D2
down to B20:D20. Then from my second sheet named "Birthdays" I need the email
to include info from cells B2:C2 down to B20:C20.

Thanks,
Chad

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

On Wed, 7 May 2008 18:41:00 -0700, Chad wrote:

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 B2:D2
down to B20:D20. Then from my second sheet named "Birthdays" I need the email
to include info from cells B2:C2 down to B20:C20.

Thanks,
Chad