Help on sending excel data through email

[shallwani]

Hi,

I am working on payroll of my company and I need to send payslips to individual users through an email.

The payslip has to be sent in the email text rather than worksheet is sent.

I need help if there is such macro available.

 

[Yahya]

see this link
http://www.rondebruin.nl/sendmail.htm

HTH

 

[shallwani]

Thanks it helped lot, but is there anyway to keep the document pasted as picture? this will ensure exact formatting as did in excel.