VB formula that prompts a worksheet to be sent in Outlook

[richardinchicago]

Looking for the VB formula that prompts a worksheet to be sent in Outlook that opens outlook and I type in the recipient.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...s-worksheet-pdf-sent-outlook.html#post5006559

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

As you have added the pdf requirement on the other post I've locked this one.