Email specific Range using macro

[shaileshgavanang]

Hi,

i am maintaining salary records in excel, where my workbook contains 3 sheets.
Sheet1, employee salary information.
Sheet2, where i am adding there no of days present according salary is getting calculate.
Sheet3, its generating salary slip.

need help to develop sheet3, i want macro to send email once i click on buton on the right side of each pay slip. and it will send email to email mentioned in the salary slip also with CC.
and only specific range in PDF format to each employee eg. for emplyee1 B2:I20 for employee2 B23:I41

is this possible to do with excel macro, i don't have much knowledge about macro.

Thank you.

[shaileshgavanang]

hi all,

is this possible?

thank you,

[john55]

see this,it's not the best one but you can try
change the path, add yours and test it!

Please Login or Register  to view this content.

[shaileshgavanang]

Dear Sir,

it's awesome, really your great...............


Thanks a lot.

[john55]

Glad I could help u!

[goodboygoodboy]

works fine but no attachments !

[john55]

Hi goodboy

if you'd like to solve your problem, please have a look here! http://www.excelforum.com/forum-rule...rum-rules.html