Auto Email worksheet from workbook

[kleaver]

I read the topic on creating a command button on a worksheet to email that sheet. We do cycle counting of our computer equipment and right now I have to to it manually, is there a way to send certain sheets from a workbook to different people at the first of the month when they are required to do there count?

 

[Jim North]

kleaver,

In this thread they discussed a similiar requirment... I think it maybe limited to Outlook though.

http://www.mrexcel.com/board/viewtopic.php?topic=20420&forum=2

 

[kleaver]

I was looking for a way to set certain sheets of the workbook to be automatically emailed, say sheet1 to be emailed on Jan 1 2003 to a specified address, then sheet2 emailed on feb 1 2003 to a specified sheet, and so on. The data will change, but the email address will not. Just trying to remove as much administrative intervention as possible. Thanks for any and all help.