EXCEL cells paste into oulook - pastes whole sheet! Help! 1

[rammers2000uk]

I am pasting a row of cells from an excel sheet into the main body of an email, whether it be HTML or RTF. the row pastes into the email fine, send email and the recipient recieves the whole sheet as an attachment. Very high security risk for me. Please help.

Lee

 

[SkipVought]

Hi

Edit/Paste Special - and select a GRAPHIC rather than an OBJECT

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[rammers2000uk]

Mmmmm, done a few tests...a bit lost here.

This is happening in Office 2k, 2003 and SBE.

If the email is in rtf, it pastes the sheet. why? if i do a paste special, in all 3 formats, different things happen.

Any further info appreciated.


Kindest regards


Lee

 

[SkipVought]

if i do a paste special, in all 3 formats, different things happen.

like WHAT?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[rammers2000uk]

Ok - RTF, copy cells, paste into email body.. = worksheet as attachment.
same with paste special, options are, unformatted text, html format and unformatted unicode text.

in html (mail) - no paste special options

in plain text - no paste special options

Not sure why this is the case and why the default is pasting the whole sheet.

Lee

 

[KenWright]

I kinda freaked out when that first happened to me

I now always paste into a blank sheet to preserve formats and then paste special values to put in the data. Then just copy that into your email. Slightly longer, but better safe than sorry depending on your data.

Another option might be to use Ron De Bruins free sendmail addin which will send just what you specify:-

http://www.rondebruin.nl/

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[rammers2000uk]

Thanks Ken

downloaded and installing on test machine.

Will update you.

Any more advice / info greatly appreciated guys.

Many thanks to all


Lee