Post the VBA code is executed I want the current excel screen is captured and send mail to particular user with Screenshot as attachment

[Rohith1324]

Hi,

Post the current VBA code is executed I want the current excel screen is captured ( screenshot ) and send mail to particular user without any other command button placed.

This screenshot shouldnt be saved anywhere in the system but should trigger the mail to specific user mail address.

Regards,
Rohith M

 

[ajetrumpet]

I have no idea if you can use vba to capture a screenshot. but if you can, you would have to make the code also push the keyboard combo "Ctrl+V" after opening am image editor like microsoft paint. I don't know any other way to send a screenshot to someone as an actual file. but you will certainly want to start your research here:

vba save screenshot to file - Google Search

 

[Rohith1324]

I have no idea if you can use vba to capture a screenshot. but if you can, you would have to make the code also push the keyboard combo "Ctrl+V" after opening am image editor like microsoft paint. I don't know any other way to send a screenshot to someone as an actual file. but you will certainly want to start your research here:

vba save screenshot to file - Google Search

Thank you for the info....but still I'm looking if any experts in message board help me with the code as i'm new to this coding.