add'l questions on emailing excel through macro (SOLVED)

[kskinne]

I have posted some previous questions on emailing within excel. I have a different question, though it is related:

I have a macro that takes a cell range, copies it as a picture to the clipboard, then pastes the picture into another sheet in the same workbook. Then the macro selects the cell range where the new picture is sitting, and copies it to the clipboard. I can then take this and copy it into a message in outlook or outlook express. here is my code:

Sub copy_picture()
Application.ScreenUpdating = False
Range("A1:L37").CopyPicture
Sheets("image of invoice").Select
ActiveSheet.Paste
Range("A1:L37").Copy
Application.ScreenUpdating = True
End Sub


My question is this: is there any way that I can automate the pasting into a message in outlook express through a macro? Or in other words, is it possible to write commands to another program into a macro in excel?

Thanks in advance,
Kevin
This message was edited by kskinne on 2002-11-07 13:24