Excel Salary payslip save as pdf and automatically send email using outlook

Good day, I have the following expectations for an excel based payslip:
1. Print Preview selected Employee payslip [Solved]
2. Print selected Employee Payslip [Solved]
3. Save selected/all Employee Payslip as PDF
4. Email selected/all Employee Payslip via Outlook to respective recipients.

I can't seem to be able to find a way around solving #3 and #4.
Appreciate all the help. Kindly see Payslips_Demo.xlsm.

Originally Posted by jaslake

Hi fortknox

This revised Code will handle Issue #3; I'll look at Issue #4.

Please Login or Register  to view this content.

Thanks, Issue#3 works like a charm, thanks.

Originally Posted by jaslake

Hi fortknox

This Code in the attached appears to handle Issue #4. The Code tests for the existence of a PDF File for the Selected Employees; if it finds one the Code sends an Email with the PDF File as an attachment. If not found the Code will tell you.

Please Login or Register  to view this content.

Boss,
Thanks a lot, this works like a charm.
You Rock!!!

Hello
This vba only works for windows ?

thanks

Thanks.

Getting error of payslip for hanna oriola does not find