Forum Discussion

worker565's avatar
worker565
Copper Contributor
Jun 07, 2021

Macro to Send Excel Table Inside an Email

Is there a way to get the macro recorder to record "Send to Mail Recipient" function with "send the current sheet as message body" option? I'm really trying to get the VBA code that converts the shee...
excel
Macros and VBA
worker565's avatar
worker565
Copper Contributor
Jun 08, 2021

I did some searching and this code actually worked really well. https://www.rondebruin.nl/win/s1/outlook/bmail1.htm. 

It seems to open Outlook and do a copy and paste including formatting. Table size is obtained to account for changes in size.

Thanks.

worker565 

Resources