How to Past an Image from Excel 2000 into MS Outlook 2000

[Guest]

I am able to attach the excel worksbook and add text to ms outlook. However,
one of the worksheets has a pivot table that I would like to copy from Excel
and paste it into the body of MS Outlook. It take forever manually. Does
anyone know the VBAic code to paste the item as a bitmap into Outlook. The
manual steps I use are:
1) In Excel highlight range pivot table covers and click copy.
2) Go to Outlook select the spot to paste the item.
3) Then in Outlook.. Edit-->Paste Special --> select image as bitmap and the
item is pasted into Outlook.

 

[Guest]

Have you tried recording a macro while doing these same steps?

 

[Guest]

That was the first thing I tried to do. The macro recorder in outlook is not
available. I think it is set up that way by the administrators here. I
record the macro in excel, but when I go over to Outlook to paste the item
the recorder in Excel does not record the move. Anyway, the recorder don't
track steps outside of Excel. I am trying to use Automation between Excel
and Outlook.

 

[Guest]

Can you paste the code you have so far?

That was the first thing I tried to do. The macro recorder in outlook is not
available. I think it is set up that way by the administrators here. I
record the macro in excel, but when I go over to Outlook to paste the item
the recorder in Excel does not record the move. Anyway, the recorder don't
track steps outside of Excel. I am trying to use Automation between Excel
and Outlook.