Email & Outlook
 

Hi

Second question for the morning!
The final stage for my template is to create a send email button/menu.

I need a macro that will open a new email message (I assume it can only work
with outlook) and attach the workbook.

Also the recipient would already be entered. (eg: )
And the subject would be "Company + Payroll + Month"

Were company, payroll & month are specific cells in the sheet (A1, A2, A3)

The macro would stop there allowing the user to type in a message in the
body if required and send it in his own time.

Thanks!

Chris