Thread: Email & Outlook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris
 
Posts: n/a
Default 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