From: TheNewGWTC@pppmppfmpfmmmmfmmmpfmmpp.pppmppfmp   
      
   Leonidas Jones wrote:   
      
   > Doug G wrote:   
   >   
   >> Leonidas Jones wrote:   
   >>   
   >>> Ray wrote:   
   >>>   
   >>>> Regardless of whether the typeface in the spreadsheet or database is   
   >>>> fixed width or variable, and regardless of whether I choose fixed or   
   >>>> variable as the email typeface, once I paste the selected cells into   
   >>>> the email I'm composing, the columns are no longer aligned.   
   >>>> Sometimes there are four blank spaces between the last character in   
   >>>> one column and the first character of the next column to the right.   
   >>>> In the two samples below, however, there seems to be a tab between   
   >>>> the columns, but the white space varies.   
   >>>>   
   >>>> What's the trick to keeping the columns nicely lined up?   
   >>>>   
   >>>> Thanks,   
   >>>>   
   >>>> Ray   
   >>>>   
   >>>> Here's a sample from Access:   
   >>>> (The column headings are: Last Name, Mar Name, First Name, Add, and   
   >>>> EM. So in the first row, the second Ariel should be under MarName,   
   >>>> Arthur should be under First Name, etc. In the sixth row, the Y   
   >>>> should be under Add.)   
   >>>>   
   >>>> Last Name    MarName    First Name    Add    EM   
   >>>> Airel    Airel    Arthur       Allen    Giordano    Rosemary   
   >>>> Ambrosio    Ambrosio    Cesare       Amodio    Amodio   
   >>>> Pasquale       Arnold    Arnold    Alfred       Asplund    Sifrit   
   >>>> Barbara Ann    Y    ?   
   >>>> Autenrieth    Autenrieth    Fred       Baffa    Baffa    Frank   
   >>>> Bambrick    Bambrick    William E.    Y    Y   
   >>>> Bange    Bange    Joyce       Barnes    Barnes    Dorothy   
   >>>> Bartels    Bartels    William J.       Bass    Bass    Ralph   
   >>>> Bennett    Bennett    Josephine       Berberich    Berberich   
   >>>> Ronald       Bernhardt    Bernhardt    Marcia       Blair   
   >>>> Blair    Ernest       Bohrman    Bohrman    Jacqueline    Y    ?   
   >>>> Bolger    Gallo    Dorothy       Boucher    Boucher    Barbara   
   >>>> Brosonski    Brosonski    Chester    Y    N   
   >>>> Brown    Brown    Carol       Butkus    Burke    Dorothy   
   >>>> Butler    Butler    Thomas       Calianese    Calianese    Mary   
   >>>> Ann       Campbell    Campbell    Lawrence       Cannon    Cannon   
   >>>> George       Cantor    Cantor    Howard       Carlock    Carlock   
   >>>> William    Y    ?   
   >>>> Cerchio    Cerchio    Gilda       Ciacciarelli    Barrett   
   >>>> Gloria    Y    ?   
   >>>>   
   >>>> Here's a sample for Word 97 (column headings are lost, probably   
   >>>> because I only selected a limited range of cells):   
   >>>>   
   >>>> Abrutyn    Blackman    Elayne       Airel    Airel    Arthur   
   >>>> Allen    Giordano    Rosemary       Ambrosio    Ambrosio   
   >>>> Cesare       Amodio    Amodio    Pasquale       Arnold    Arnold   
   >>>> Alfred       Asplund    Sifrit    Barbara Ann    Y    ?   
   >>>> Autenrieth    Autenrieth    Fred       Baffa    Baffa    Frank   
   >>>> Bambrick    Bambrick    William       Bange    Bange    Joyce   
   >>>> Barnes    Barnes    Dorothy       Bartels    Bartels    William   
   >>>> J.       Bass    Bass    Ralph       Bennett    Bennett   
   >>>> Josephine       Berberich    Berberich    Ronald       Bernhardt   
   >>>> Bernhardt    Marcia       Blair    Blair    Ernest       Bohrman   
   >>>> Bohrman    Jacqueline    Y    ?   
   >>>> Bolger    Gallo    Dorothy       Boucher    Boucher    Barbara   
   >>>> Brosonski    Brosonski    Chester    Y    N   
   >>>> Brown    Brown    Carol       Butkus    Burke    Dorothy   
   >>>> Butler    Butler    Thomas       Calianese    Calianese    Mary   
   >>>> Ann       Campbell    Campbell    Lawrence       Cannon    Cannon   
   >>>> George       Cantor    Cantor    Howard       Carlock    Carlock   
   >>>> William    Y    ?   
   >>>> Cerchio    Cerchio    Gilda       Ciacciarelli    Barrett   
   >>>> Gloria    Y    ?   
   >>>>   
   >>>>   
   >>>   
   >>>   
   >>> Are you composing in plain text, or html?   
   >>>   
   >>> I always noticed this pasting from spreadsheets in plain text, and I   
   >>> alway just corrected it manually.  I don;t know if it would behave   
   >>> better in html, but it might.   
   >>>   
   >>> Lee   
   >>   
   >>   
   >> Column alignment is retained when I use the HTML editors in Mozilla   
   >> 1.7.12 and Thunderbird 1.0.7.  Leading or trailing spaces in cells can   
   >> affect alignment.   
   >   
   >   
   > Thanks Doug, that's what I suspected.   
   >   
   > Lee   
   There is a work around.  What I found will let you paste everything in   
   the columns, rows, and even all the colours that you designed.  I've   
   tried it out with an Excel document and it works.   
      
   Download and install OpenOffice: http://www.openoffice.org/.  This   
   program will give you something called HTML Document.  Open this, copy   
   whatever you want copied, and when you're ready to paste it into the   
   HTML Document, click on Edit, Paste Special, and choose Formatted Text   
   {RTF}.  Then you copy what you just pasted in the HTML Document and   
   paste that into your email.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)