Use VBA to email active worksheet without using an attachment

[BetterBeef]

I have looked around the web as well as this forum and I cannot find an answer to my question, which is why I am posting it here.

I would like to put some VBA code together that allows me to embed the active sheet in my Excel workbook into an email. Most of what I have seen on the web is how to attach an active workbook into an email.

Essentially I want the Macro to do the following task that I would do manually.

File, Send To, Mail Recipient not as attachment.

Any idea of how to do this?

 

[VoG]

I honestly don't know - I can only suggest that you try it.

 

[BetterBeef]

I decided to make a distribution list in one of the tabs of the file. VBA then creates a string of these email addresses and applies them to the "To:" part of the email. This was the closest thing I could think of.

 

[Ron de Bruin]

Use .Display instead of .Send in the code

Then the user can use the Outlook addressbook

 

[BetterBeef]

Ron,

Not very long after I accidently sent the spreadsheet to you, I noticed your code showed to use .Display as an alternative to .Send. I appreciate you posting that here to show myself and other users. Your code works great! I appreciate your help!

Thanks.