On 4/23/05 7:56 PM, "revDAVE" <[EMAIL PROTECTED]> wrote: > I am attempting to send Tab delimited e-mail text in email from my > WebServer using ColdFusion mail tag -CFMAIL- - (although I believe > ColdFusion doesn't really matter much in relation to my problem ... - also > ... I am sending plain text E-mail rather than HTML e-mail) > > > Inside the mail tag, I am successfully using certain ASCII codes ... Chr(13) > - Chr(10) Chr(34) etc...... But having some trouble using Chr(9) > > - the short story: the other ASCII codes appear fine in my Macintosh > entourage plain text e-mail and so does Chr(9) (tab key) ... However > somehow Chr(9) (tab key) is getting lost on my PC using outlook Express > whether I view it as HTML mail or plaintext e-mail - it seems to get > converted to a space or something... > > - the ultimate goal is to be able to copy and paste the text into a text > file that can be imported into Excel.... > > - when I view the invisible characters in Microsoft word on my mac - I can > see everything including the tab key on the Macintosh however on the PC > Microsoft word shows everything correctly except the Chr(9) (tab key) - > which seems to have been converted to a space... > > Question: is there some way to fix this so the Chr(9) (tab key) will show up > in all e-mail programs on both platforms?
No, it won't show up on _either_ platform. Tab characters (ASCII 9) are used for one specific purpose in encoded message sources: they indicate a continuation line within a header when the line is so long it has to break (i.e., longer than 76 characters). Therefore all email clients convert tabs to spaces (usually 3 or 4) when sending email. Most do what Entourage does and do the conversion at the moment you type or paste the text in. There's nothing you can do about that except not to send as text. If you send as HTML the tabs might get encoded as quoted-printable and get re-constituted at the other end, but I'm pretty sure they get changed to spaces too - certainly in Entourage they do - again when typing or pasting). You'll have to substitute an unusual symbol or symbols - such as � or ��� - for the Tab character, and then re-concert it back when importing into Excel. You can tell Excel to use the symbol(s) as the delimiter. -- Paul Berkowitz MVP MacOffice Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html> AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/> PLEASE always state which version of Microsoft Office you are using - **2004**, X or 2001. It's often impossible to answer your questions otherwise. -- To unsubscribe: <mailto:[EMAIL PROTECTED]> archives: <http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/> old-archive: <http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
