Sending Difft Sheet as a seperate file thru email

[prasadpain]

Hi all,

I need a small help....
I have an excel which contains 40 sheets..
I need to send that excel sheets to 40 different pepole as a new file
thru email.....
could you pls help me to make it easy n fast....

This is the payslip of the employees..i wanna send difft sheets to
difft people....
there will be one employee id for all the employees
email id is there in the employee master file...(including name,
employee id, email id) etc.

i do no have any idea abt coding ...but wish to learn...

Regards,
Prasad

 

[Ron de Bruin]

Hi prasadpain

I have a few examples on my site
Maybe "Mail every worksheet with address in A1"

Look also the templates (very easy) in the "Other Tips" section
http://www.rondebruin.nl/sendmail.htm