Alt+Print Screen then Opens new Outlook Mail Message and Pastes into Body of Email

Hello

I have searched all over the net and I have not found a solution that I can adapt to help me with this.

I have found a solution using simple VB code to do the action of Alt+Print Screen to get the image I require stored in the Clipboard. Using;

Private Sub CommandButton1_Click()
Application.SendKeys "(%{1068})"
DoEvents
End Sub

I have also found a great bit of VB which allows you to select a range of cells in Excel and then it converts thats into a Bitmap Image and places that into a new email message.

However I can not marry the 2 together which will allow me to use the the print screen image which is stored in the Clipboard and place in into a new email message.

Any help would be great.

Hi

The following code works for me in Excel/Outlook 2007 to copy an image of the active sheet into an email message. It will only display the email (the user has to press send). Also, it uses Sendkeys, which can be unreliable.

Dion

Please Login or Register  to view this content.

Thankyou very much this has worked perfectly.

Sorry about the late reply back.

Alex