Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pasting Excel into Outlook (Excel 2000)

    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

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Pasting Excel into Outlook (Excel 2000)

    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.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Excel into Outlook (Excel 2000)

    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

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pasting Excel into Outlook (Excel 2000)

    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

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Pasting Excel into Outlook (Excel 2000)

    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! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Hope you get a solution there.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Excel into Outlook (Excel 2000)

    Thanks, John, for your time.
    --cat

  7. #7
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Pasting Excel into Outlook (Excel 2000)

    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?
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •