Emailing a Workbook

[kewllee15]

First of all, I am trying to figure out if this is even possible. I need to be able to insert a button into an excel spreadsheet that will attach the spreadsheet to an outlook mail message. But I need the message to open so the user can manually put in the "To" and add "CC" and "BCC" if needed. I have found the code for just attaching the workbook into an email and automatically sends it, but is there a code that will allow me to do editing?

[jaslake]

Hi kewllee15

Welcome to the Forum!!!

You didn't post the Code you're using but somewhere in that Code you'll have a line

Please Login or Register  to view this content.

Change that to

Please Login or Register  to view this content.

[kewllee15]

First of all, I am trying to figure out if this is even possible. I need to be able to insert a button into an excel spreadsheet that will attach the spreadsheet to an outlook mail message. But I need the message to open so the user can manually put in the "To" and add "CC" and "BCC" if needed. I have found the code for just attaching the workbook into an email and automatically sends it, but is there a code that will allow me to do editing?

[mikerickson]

What is this code that you have?

[kewllee15]

I was trying to use Ron de Bruin's code ( http://www.rondebruin.nl/win/s1/outlook/amail1.htm ) and attaching that to a form control button... does that work?

[AB33]

Duplicate post
http://www.excelforum.com/excel-prog...-workbook.html

[jaslake]

Hi kewllee15

Sure, I've used his Code many times. Change .Send to .Display in the Code. The User can then edit the Email.

If you don't find it, post the Code...I'll show you.

[jayesh25]

Perhaps is this something what you're looking for?

Please Login or Register  to view this content.