Pasting Excel into Outlook (Excel 2000)

Topic

New Reply

Hi, any help/hints would be appreciated. I’m starting a new job and whenever I paste from Excel into an Outlook email message, the pasted portion of the message does not get sent. It appears to the sender (me) that the pasted portion is there, but the receipient gets nothing where the pasted excel should be. There are people in the company that CAN paste excel into email and, then, there are some who cannot. Our IT guys have not been able to help so far. So, any help from this lounge would be appreciated.

–cat

Reply | Quote

Replies

Is your platform all Win 2000 and Office2000? If so, have you used the E-Mail button which comes on the standard Excel 2000 toolbar and what is the result? In Outlook, have you used the PasteSpecial, Text option whn you paste into the e-mail?

Are your default Outlook settings PlainText, RichText (RTF) or HTML? If HTML, what are your security settings?

Are you trying to paste as text or as an embedded object? (Perhaps you could describe the steps you use if if they are not a straight copy-&-paste.) What happens when you paste a portion of a Word document into an e-mail and send it? Can you receive Excel data pasted into the sender’s e-mail?

(Not all these questions may be relevant, but we have to know a bit more.)

Reply | Quote

Sorry … we use Windows 2000 and Office 2000 throughout. I did use the email button — this works, but it sends the entire sheet. I need just a selection. Our default settings are RichText. I used the typical copy/paste (CTRL-C and CTRL-V) commands. I can receive a sender’s email that includes a pasted excel selection. I can copy/paste Word selections into Outlook, too. Which is the work-around that my IT guys came up with. Copy/Paste from Excel to Word, then Copy/Paste into Outlook … hmmm. I’ve, also, tried using the command, Copy Picture, from the Edit menu (this shows up when I hold down the Shift key before clicking on the Edit menu). This, too, doesn’t work.

Again, thanks.
–cat

Reply | Quote

I see you have crossposted this in Outlook, and that’s where I expect the problem will be. Which also means I haven’t thought of anything! Hope you get a solution there.

Reply | Quote

Thanks, John, for your time.
–cat

Reply | Quote

I don’t use Excel much, but I note that if you copy a range in Excel and then choose Edit|Paste Special… in Outlook, you get very different options depending on whether the sheet is still open (see illustration). If you use Paste Special and always choose Rich Text, does that work for everyone?

Reply | Quote

I have a similar problem with embedded information going to people not using LotusNotes.
I find that attaching the file is the best way to go as it seems to be the most generic and acceptable across platforms.

If you want to sent the “picture” of a chart and not the underlying data and other spreadsheet items:
Paste the chart or data in WORD (paste-special – picture) and then you can attach the Word document without anyone getting your spreadsheet at all, just the relevant info.

Steve

Reply | Quote