Gustav Brock
Gustav at cactus.dk
Tue Nov 6 03:23:20 CST 2007
Hi Mark et al The problem is that the plain text body of the message from Hotmail is garbled as no line breaks exist. This is a direct cut and paste of the encoded body part in the mail you sent directly to me. Here's a snip: --- From: markamatte at hotmail.comTo: accessd at databaseadvisors.comSubject: RE: [A= ccessD] ...gurus onlyDate: Fri, 2 Nov 2007 20:44:24 +0000 > ...now if only I could learn to swallow my pride and just ask before > sp= ending days running in circles. ...ouch...you're gonna hate this suggestion= . Guessing from your description below...you used about 3 fields in your or= iginal table to get this output. We'll use the fields:field1=3DSet---this = is where your data1,data2 stuff wentfield2=3DValue---this is where your 1,2= ,5,4,2,3,4...wentfield3=3DLtr--(letter)...where your w,x,y,z Assuming this = is how your data is stored...the results you want can be achieved using a s= ingle crosstab. --- However, also an HTML part is included, and if your mail client defaults to HTML, it will read that for quoting. That looks similar to this snip: --- From: markamatte at hotmail.com To: accessd at databaseadvisors.com Subject: RE: [AccessD] ...gurus only Date: Fri, 2 Nov 2007 20:44:24 +0000 > ...now if only I could learn to swallow my pride and just ask before > spending days running in circles. ...ouch...you're gonna hate this suggestion. Guessing from your description below...you used about 3 fields in your original table to get this output. We'll use the fields: field1=Set---this is where your data1,data2 stuff went field2=Value---this is where your 1,2,5,4,2,3,4...went field3=Ltr--(letter)...where your w,x,y,z Assuming this is how your data is stored...the results you want can be achieved using a single crosstab. --- No problem here. So the issue is, that Hotmail generates garbled plain text and mail clients (including the mail reader part of the list server) faithfully reads that part for quoting or forwarding to the list. As I don't use Hotmail while other list members do you may discuss with these if some option can be changed to address this issue. /gustav