Excel to Email VBA Question

Hi All,

I am using a macro in VBA in an attempt to have it open a new email in outlook, attach the full workbook to the email, and have it auto populate some of the email details.

I have a macro that is sending the full workbook view outlook but it does not open a new message to do so. I actually want to be able to hit the submit button on the email rather than it all happening in the background, here is the code I am using:

Please Login or Register  to view this content.

Does anyone have any thoughts on how I can modify this code to have it open up a new email and then require the user to hit send instead of it all happening in the behind the scenes?

Any help anyone may be able to provide would be greatly appreciated!

Thank you!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)