I have made a bit more headway but I just cant wrap my head around what to do next. I have found this macro that I can tell works cause when I run it and then open WORD and just do a ctrl+v it actually pastes the screenshotthat I was expecting in. But how do I get the paste command and combine it with the rest of my code (ie: to, subject, body, etc)
Here is the 'copy' code I found:
Sub Macro1()
fmta = Application.ClipboardFormats
Range("A11:K22").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
' Use Watch window to examine the Clipboard formats-FmtA
End Sub
Honest I am trying ...
Bookmarks