Convert this word VBA to excel

**bdouglas1011** · 08-01-2014, 09:42 PM

How would I convert this Word VBA to Excel?

Please Login or Register  to view this content.

**HaHoBe** · 08-02-2014, 01:50 AM

Hi, bdouglas1011,

without knowing how your workbook or range looks like and what you want it to look in Outlook maybe have a look at Mail from Excel with Outlook (Windows) where you should find a fitting code for your need or attach a sample workbook with situation as is and as wanted.

Ciao,
Holger

**bdouglas1011** · 08-02-2014, 02:13 PM

I have attached the sheet. What I would like is when the user clicks on the macro button for it to send to email I would like the macro:
1. The macro needs to look and see if outlook is running and if not go ahead and start it first
2. Copy the spreadsheet and place it directly into outlook. Hopefully the Logo Picture Comes with it.
3. I would also like it to save a PDF of the Morning report into a File folder called Morning Reports on the desktop.
4. I would like it to attach the workbook to the email
5. I would like it to place the default email signature below the body of email.
6. I would also like once you click on the macro a pop up question would show "If you would like to enter a comment before your email Choose YES or Choose NO to go directly to email."

Thanks for your help