This web site answered my questions about emailing sheets etc. Hope it helps.

Ron's Excel Page:
http://www.rondebruin.nl/

"Murtaza" wrote:

I have a Workbook (excelfile) with multiple worksheets (around 25), and I
want to conditionally send each worksheet as a seperate Workbook (excel
file). Macro should get Send Criteria (like if A1="Ready for Send")