copy paste from excel to mail problem

[Gordon Blackstone]

hello every one!

sure this question was already ased... but i can't fin any answer.

why and how can i change this:

when i copy several cells from excel and i want to paste the content
into mail, i always have an image and no editable text!?

any help?

 

[Bob Greenblatt]

hello every one!

sure this question was already ased... but i can't fin any answer.

why and how can i change this:

when i copy several cells from excel and i want to paste the content
into mail, i always have an image and no editable text!?

any help?

I guess that depends on your mail program. It seems to work fine in
Entourage. Check the paste command of your mail program to see if there are
any paste options, like paste text.

 

[Gordon Blackstone]

I guess that depends on your mail program. It seems to work fine in
Entourage. Check the paste command of your mail program to see if there are
any paste options, like paste text.

no choice... in the native mail mac application...

 

[Joe]

I just tested this with NetScape 7.2. I copied 6 cells arranged as 2
columns by 3 rows. When I pasted to NS mail I got the text in editable
form on 3 lines just as it was in Excel. I have used NS for so many
years I can't bring myself to change. Never tried Apple Mail.

-Joe

 

[Bernard Rey]

Gordon Blackstone  :

when i copy several cells from excel and i want to paste the content
into mail, i always have an image and no editable text!?

Could you please give a detailed step by step explanation? I have tried to
paste some standard cells (text, numbers and formulas) from Excel 2004 to
Mail 2.0.7 (comes with Tiger) and did have editable text in the message.

Using the "copy" and "paste" options from the "Edit" menu, I have tried it
with the Mail format set to "Plain Text" as well as "RTF": it hasn't been
pasted as an image...

 

[Gordon Blackstone]

Gordon Blackstone  :


Could you please give a detailed step by step explanation? I have tried to
paste some standard cells (text, numbers and formulas) from Excel 2004 to
Mail 2.0.7 (comes with Tiger) and did have editable text in the message.

Using the "copy" and "paste" options from the "Edit" menu, I have tried it
with the Mail format set to "Plain Text" as well as "RTF": it hasn't been
pasted as an image...

plain or rich text does not change anything...
but what i've notices is:
- with narrow column -> editable text
- with wide column -> Image...

exple: 2 cells a1, a2, wih text, column "a" width 120, result not editable

BUT

if the column has a width of 20 the pasted text is editable

 

[Bernard Rey]

Gordon Blackstone:

plain or rich text does not change anything...
but what i've notices is:
- with narrow column -> editable text
- with wide column -> Image...

exple: 2 cells a1, a2, wih text, column "a" width 120, result not editable

BUT

if the column has a width of 20 the pasted text is editable

I still can't see this happen! I've tried creating a brand new sheet,
stretched the "A" column width to 120, filled cell "A1" with text (over 256
Chars, formatted bold and red), filled a couple of other cells... Text is
always editable when pasted in Mail (as with any other mailer I tried)...

Is there some setting I'm missing?

 

[Joe]

I just tried about the same thing but also forced a carriage return
within half of the cells so the cells had two lines of text. The only
effect I saw was that the text from the cells with a carriage return
was enclosed by quotation marks. The carriage returns within a cell
also appeared in the pasted text in NS Mail.

-Joe

 

[CyberTaz]

Hi All -

FWIW, I *cannot* force this behavior, either.

OS X 10.4.6
Mail 2.0.7
Office 11.2.3

I thought it might be a font issue, but no matter what font I use - plain
text or HTML - it pastes as editable text regardless of column width or
anything else. (I'm also assuming the '120' is mm.)

Sorry I haven't anything more to offer

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[CyberTaz]

Just a wild guess here, but you don't happen to have the Shift key involved
while you are Copying, do you? If so, that is a Copy As Picture command,
which would explain a lot.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Gordon Blackstone]

Just a wild guess here, but you don't happen to have the Shift key involved
while you are Copying, do you? If so, that is a Copy As Picture command,
which would explain a lot.

Regards |:>)
Bob Jones
[MVP] Office:Mac

- i have office x and mail 1.3.11 on macos 10.3.9
- i'm not using the shift command
- ths is the same problem when i paste into texedit, except it does
work fine when the document is in "paint text" format.

maybe the is some tweeking to do in my system? related to the
copy/paste fonction?

 

[Gordon Blackstone]

- i have office x and mail 1.3.11 on macos 10.3.9
- i'm not using the shift command
- ths is the same problem when i paste into texedit, except it does
work fine when the document is in "paint text" format.

maybe the is some tweeking to do in my system? related to the
copy/paste fonction?

anyway, thank you all for your help.

 

[Jim Gordon MVP]

Hi Gordon,

If you save the Excel sheet as a web page then open the HTM file in a
web browser or HTML editor you should be able to copy the the range of
cells and paste that into Mail.

Another option would be to copy the desired range of cells in excel then
switch to Microsoft Word and use Edit > Paste Special > HTML Format.
Then copy and paste that into Mail.

Both of my examples presume Apple Mail can accept HTML tables as pasted
input.

-Jim

 

[Gordon Blackstone]

Hi Gordon,

If you save the Excel sheet as a web page then open the HTM file in a
web browser or HTML editor you should be able to copy the the range of
cells and paste that into Mail.

Another option would be to copy the desired range of cells in excel
then switch to Microsoft Word and use Edit > Paste Special > HTML
Format. Then copy and paste that into Mail.

Both of my examples presume Apple Mail can accept HTML tables as pasted input.

-Jim

thanx jim,

or copy excel cells, paste them into textedit text format, copy again
and paste in mail...
but weird thing is that not evey one has the same problem?!

 

[gsjtitan]

*hello every one!

sure this question was already ased... but i can't fin any answer.

why and how can i change this:

when i copy several cells from excel and i want to paste the content
into mail, i always have an image and no editable text!?

any help?

I ran in to this same problem today, and determined it is a result of
having non text characters in the field. So, if you have a tab, CR, LF
etc, excel puts quotes around the cell conctents.

It is a function of excel, not your email program. Either eliminate
the non-text characters, or strip the quotes after the fact.

-Greg

 

[Gordon Blackstone]

I ran in to this same problem today, and determined it is a result of
having non text characters in the field. So, if you have a tab, CR, LF
etc, excel puts quotes around the cell conctents.

It is a function of excel, not your email program. Either eliminate
the non-text characters, or strip the quotes after the fact.

-Greg

not for me..........

anyway, thanx all of you for your inputs