Copy/Paste from Excel to O/Express

Justin_Credit · 23 April 2005 at 1:51PM

I used to be able to copy and paste a worksheet from excel directly into outlook express. This was for circulating local sporting league results to the membership of our club.

I had a problem with the pc about a year ago and had to re-load Win98 on to the machine. Since then I have not been able to do this copy and pasting. Instead, I have had to copy/paste from excel into word and then send the Word doc as an attachment as most, if not all, of the membership don't have excel.

I would really like to be able to return to my original method as it was much quicker and easier.

Does anybody have any ideas? I have been into options in O/Express but can see nothing to alter there in the settings. Is it a Win98 problem?

Any suggestions gratefully received.

JC

Tony_H_3 · 23 April 2005 at 1:55PM

I take it you select the area you want to copy & then right click, select copy. Then goto OE create mail then right click & paste.

What happens when you do this?

DVB_3 · 23 April 2005 at 1:59PM

Most probably e-mail compose settings reverted from HTML to plain text.

Justin_Credit · 25 April 2005 at 9:14PM

Thanks for the replies guys

Tony_H, when I paste the selected area of excel file to OE the figures do paste but not in the table format that they were originally in, just a jumble really.

DVB, I was wondering if it was something to do with HTML/Plain Text. I think I have been to options and have set to HTML, but I will check again. If you have any more ideas please keep them coming.

Regards

JC

DVB_3 · 25 April 2005 at 9:32PM

What exactly do you get when you try to paste? Can you provide an example?

Justin_Credit · 26 April 2005 at 9:40AM

DVB

When I paste I get rows something like this:

Name 5 4 1 245 220 25 11

The figures are correct but as they are not in any sort of table they mean nothing.

The column headings are also printed but, again, do not line up with the relevant numbers so are meaningless.

HTH

JC

DVB_3 · 26 April 2005 at 10:04AM

Have you tried switching format to Plain Text?

I tried to reproduce this error with HTML and couldn't. Could you do the following - provided you're in HTML Compose, copy and paste as you would normally do (example above would be fine), select View->Source Edit, than choose Source tab, and finally copy and paste everything you've got there here. I'll try to inspect the raw html code you're getting.

Justin_Credit · 26 April 2005 at 1:57PM

OK DVB here goes, hope it helps

Regards JC

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE id=ridTitle>Blank</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"><BASE
href="file://C:\Program Files\Common Files\Microsoft Shared\Stationery\">
<STYLE></STYLE>

<META content="MSHTML 6.00.2800.1498" name=GENERATOR></HEAD>
<BODY id=ridBody bgColor=#ffffff background="Blank Bkgrd.gif">
<DIV>Friday Spring League
2005 Up to & Including
22nd April
 Matches Points
 Name P W L F A Diff Pts Claude
Rossi 7 6 1 217 164 53 13 Dan
Falvey 6 4 2 183 155 28 10 Tel
Ryan 7 5 2 177 158 19 10 Phil
Passmore 7 4 3 185 176 9 10 Mark
James 7 4 3 184 190 -6 9 Tony
Carlsen 8 2 6 223 250 -27 9 Chris
Adams 7 3 4 153 155 -2 7 Andy
Skilling 6 2 4 171 175 -4 7 Paul
Preece 3 3 0 101 75 26 6 Ian
Scott 4 2 2 119 105 14 5 Byron
Gates 2 1 1 54 61 -7 3 Idris
Davies 6 1 5 139 174 -35 3 Charlie
George 6 1 5 118 175 -57 3 Pop
Spooner 5 1 4 109 149 -40 3 Steve
Bryant 3 0 3 52 85 -33 1 </DIV>
 </BODY></HTML>

DVB_3 · 26 April 2005 at 10:36PM

Strange problem you seem to have: Excel table does not get properly converted into HTML. Try the following: select your source data in Excel, copy it, open Word, in Word select Edit->Paste Special, paste the data as html. What does the Word display? If what you need is there - try to select the table in Word and pasting it into OE.

Justin_Credit · 27 April 2005 at 12:15AM

Thanks DVB,
The table copies from Excel and pastes into Word no trouble at all. I have just done it as you said to make sure again. This is what I have been doing to send out the results to members as they all have Word.

Regards

JC

DVB_3 · 27 April 2005 at 12:18AM

Justin_Credit wrote:

Thanks DVB,
The table copies from Excel and pastes into Word no trouble at all. I have just done it as you said to make sure again. This is what I have been doing to send out the results to members as they all have Word.

Regards

JC

No, I meant not to attach the Word file, but to copy the information from the Word and paste it directly into the OE. Or have I misunderstood you?

Copy/Paste from Excel to O/Express

Comments

Confirm your email address to Create Threads and Reply

🚀 Getting Started

Categories

Is this how you want to be seen?

Get our FREE Weekly email full of deals & guides - and it’s spam-free