Copy Lotus Notes mail contect to Excel File by Row

[MIC]

Hi, I've got a problem that there are some table contect inside the Lotus
Notes mail, and I want to copy it and paste it to a Excel file, e.g. I
highlight the column of the table contect in Notes, and paste it to the
Excel file ( paste the contect by Row )....

I would like to set the Excel to Paste everything by Row, and not by Column,
can Excel do that, thanks a lot...

btw, I cant use Paste Special if I copy the contect form Lotus Notes & Paste
it to Excel file.....
when I paste the contect, it promted me to select source file, but no
"Transpose" option there ......


Thanks a lot

 

[Beth Melton]

Hi, I've got a problem that there are some table contect inside the Lotus
Notes mail, and I want to copy it and paste it to a Excel file, e.g. I
highlight the column of the table contect in Notes, and paste it to the
Excel file ( paste the contect by Row )....

I would like to set the Excel to Paste everything by Row, and not by
Column, can Excel do that, thanks a lot...

btw, I cant use Paste Special if I copy the contect form Lotus Notes &
Paste it to Excel file.....
when I paste the contect, it promted me to select source file, but no
"Transpose" option there ......

Why not paste everything by column in Excel and then when you're finished,
select your pasted data and then use the Paste Special Transpose.

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx