Sending Active Sheet Without Saving it

[Shay A]

Hi,
I have tried google it but didn't quite find what I was looking for. Any code would be appreciated.

Thanks,
Shay

 

[SirJB7]

Hi, Shay A!
What do you mean by send? Attachment by mail, cells copied as text... please elaborate, define method and container/format.
Regards!

 

[Shay A]

Hi,
I mean attachment by mail.
TY

 

[SirJB7]

Hi, Shay A!
You can't attach an open file to an email.
Regards!

 

[Chihiro]

You need to create temp file and then kill it after email is sent.

You will find plenty of example in Ron DeBruin's site.
See link for an example.
https://www.rondebruin.nl/win/s1/outlook/amail2.htm

 

[NARAYANK991]

Hi ,

This may be a possibility , but requires you to go through these links :

https://gist.github.com/mvark/8c523eb47670c2fc8da4

http://analystcave.com/excel-use-c-sharp-in-excel-vba/

Narayan