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

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 a
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.

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

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

"ExcelG.I.T" wrote:

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 a
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.

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

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.

"JNW" wrote:

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

"ExcelG.I.T" wrote:

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 a
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.

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

Can you paste the code you have so far?

"ExcelG.I.T" wrote:

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.

"JNW" wrote:

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

"ExcelG.I.T" wrote:

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 a
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.