ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to put a STATIC version of a range of cells into an Outlook em (https://www.excelbanter.com/excel-discussion-misc-queries/184140-how-put-static-version-range-cells-into-outlook-em.html)

Jane0218

How to put a STATIC version of a range of cells into an Outlook em
 
I use Excel 2003 and Outlook 2003, both are Office versions.

Every time I copy and try paste a range of cells from an Excel worksheet
into an Outlook email (not a file; just a range of cells), they look just
great--within the borders of the email page. I want to sent STATIC
images--no interactivity required.

When I send the emails, the recipients get an image/worksheet(?) in their
email that is far past the margins and the recipients can't see all the
cells
that end up disappearing to off to the right.

I'm told there used to be a "snapshot" icon in Excel that allowed a static
image to be copied and then pasted into Outlook emails. I don't see that
icon in Excell 2003.

Is there a way to do this? I've tried copying the cell range into Paint,
and
the copying that over to Outlook, but sometimes the image does get to the
recipient, especially if the recipient forwards the emai to someone else.

What do I need to do to send a STATIC image of a range of cells without
losing information off the side of the email page?


Gord Dibben

How to put a STATIC version of a range of cells into an Outlook em
 
I will state here that I have no problem copying and pasting a range of cells
only into an Outlook email body but maybe an alternate method..............?

Try selecting the range of cells then SHIFT + EditCopy as Picture/.

Paste into the email body.

The "snapshot" icon would be the Camera Icon found under
ToolsCustomizeCommandsTools but that creates a dynamic and interactive copy.


Gord Dibben MS Excel MVP


On Thu, 17 Apr 2008 10:45:00 -0700, Jane0218
wrote:

I use Excel 2003 and Outlook 2003, both are Office versions.

Every time I copy and try paste a range of cells from an Excel worksheet
into an Outlook email (not a file; just a range of cells), they look just
great--within the borders of the email page. I want to sent STATIC
images--no interactivity required.

When I send the emails, the recipients get an image/worksheet(?) in their
email that is far past the margins and the recipients can't see all the
cells
that end up disappearing to off to the right.

I'm told there used to be a "snapshot" icon in Excel that allowed a static
image to be copied and then pasted into Outlook emails. I don't see that
icon in Excell 2003.

Is there a way to do this? I've tried copying the cell range into Paint,
and
the copying that over to Outlook, but sometimes the image does get to the
recipient, especially if the recipient forwards the emai to someone else.

What do I need to do to send a STATIC image of a range of cells without
losing information off the side of the email page?



Jane0218

How to put a STATIC version of a range of cells into an Outloo
 
Thanks for the SHIFT + EditCopy as Picture tip.

"Gord Dibben" wrote:

I will state here that I have no problem copying and pasting a range of cells
only into an Outlook email body but maybe an alternate method..............?

Try selecting the range of cells then SHIFT + EditCopy as Picture/.

Paste into the email body.

The "snapshot" icon would be the Camera Icon found under
ToolsCustomizeCommandsTools but that creates a dynamic and interactive copy.


Gord Dibben MS Excel MVP


On Thu, 17 Apr 2008 10:45:00 -0700, Jane0218
wrote:

I use Excel 2003 and Outlook 2003, both are Office versions.

Every time I copy and try paste a range of cells from an Excel worksheet
into an Outlook email (not a file; just a range of cells), they look just
great--within the borders of the email page. I want to sent STATIC
images--no interactivity required.

When I send the emails, the recipients get an image/worksheet(?) in their
email that is far past the margins and the recipients can't see all the
cells
that end up disappearing to off to the right.

I'm told there used to be a "snapshot" icon in Excel that allowed a static
image to be copied and then pasted into Outlook emails. I don't see that
icon in Excell 2003.

Is there a way to do this? I've tried copying the cell range into Paint,
and
the copying that over to Outlook, but sometimes the image does get to the
recipient, especially if the recipient forwards the emai to someone else.

What do I need to do to send a STATIC image of a range of cells without
losing information off the side of the email page?





All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com