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.

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.

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.

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.