Hi All,

Hoping you can help me, I have a workbook in which I would like to send two worksheets as a workbook via outlook.

I have tried messing around with some code I have found on the forums but Im no expert at VB.

The two Sheets I want to send are named "Customer Timesheet" and "Employee Timesheet"

The email address and title of the excel workbook is to be pulled from another sheet called "Payroll Data"

Please see an Example of the code I have been playing with below

Please Login or Register  to view this content.
I dont know if i am even close with this code, Any help greatly appreciated.

Regards,
Simon