I have an Outlook table (a contacts folder) that I want to copy and
paste into Excel. I have set all the fields that I want to show up in
my Outlook view, including the Notes field. I have a lot of
information in the Notes field of the Outlook form. Every time I press
enter to start a new line in the Outlook Notes field, it screws up the
copy and paste in Excel by starting a new row there. I.e. Excel simply
doesn't recognise that this information should still appear under the
same column. I have tried Paste Special but that didn't help. Any
ideas?
I need a simple way to fix this, as I will be doing this quite a lot.

---

Request for Question Clarification by hummer-ga on 03 Sep 2004 18:27 PDT

Hi again, Jim,

Rather than pressing 'enter' at the end of each line, try pressing the
'tab' key. You can either press it several times until it moves to the
next line, or you can set it to go all the way to the end of the line
you are in and then you would only have to press it one more time to
go to the next line. Hopefully that will work - please let me know if
that helps you out.

Regards,
hummer

---

Request for Question Clarification by hummer-ga on 07 Sep 2004 18:40 PDT

Hi Jim, good to hear from you.

I don't use Outlook so I can't have a look at it for myself. Is there
a sliderule at the top of your document?  If so, click on it and while
holding the mouse button down, slide it all the way over to the right
margin. Now test your tab key - it should go over to the end. If not,
your slide rule may be divided up into sections. Slide all the
sections over and that should do it.  If there's no sliderule, then I
haven't a clue - perhaps someone else will be able to help.

Fingers crossed,
hummer

I believe there is a Data feature called something along the lines of
'text to columns' for incorporating data into Excel when it is causing
problems. Been a year or so now since I used it, so can't be more
helpful than to tell you that it exists

wolvies

Hummer,

Pressing tab to the end of the line is definitely too tedious. I am
not sure if I will end up liking setting it to the end of the line
either, but I would like to give it a try. Can you let me know how to
do that.

Wolvies,

That sounded really promising at first, but it seem like Excel treats
the spaces that separate one column from another in Outlook as if they
were tab delimited. That means, if I set Text to Columns to something
other than tab, I have no option of keeping the Outlook columns apart
(because they are tab delimited).  Any other ideas???

Hummer,

There isn't a sliderrule available but thanks for all your help...

Hi Jim,

I'm just going out the door to visit our son for a few days or I'd
look at this some more. Try using the right arrow or down arrow to go
to the next line. The object is to *not* use the enter key.

Must run... 
hummer

Just for everyone out there who may need a solution for this as well.
I found something like a workaround: If you put the entire text in the
Notes field into quotation marks and copy and paste into Excel from
there, it will maintain the proper columns. (You have to make sure
that you turn on Warp Text to see everything). The only drawback is
that every time you hit enter in Outlook, it produces a little square
in Excel. However, I can handle that.

Thanks again everyone for all your help!

I am not quite sure what the problem is, but as far as I understand
you copy data from Email forms to Excel workbooks. There is a rather
simple solution to this, if you know how to do it ;)

I would create a reference to outlook from excel vba code, with the
outlook object, check the inbox for all emails that have the relevant
form in them, copy the data from these forms into excel and
subsequently move the emails from the inbox to e.g. a processed
folder.

This would automatically process all your forms for you.