Topic Options
#55145 - 08/07/17 12:50 PM Email Input message body data question
joersmith Offline
OL Expert

Registered: 08/31/06
Posts: 163
Loc: Mount Laurel, New Jersey
I am trying to set up a process to use the data from the message body of an email. When I send to Planet Press from outlook with the message set to plain text I get a number of formatting characters that were not in the original body. How can I use the body of an email?

Sent:
PRINT DATE: <temp.datetime_from>
CLIENT CODE: <temp.ari_lessee_code>
CLIENT VEH NO: <temp.ari_cli_veh_no>
VEHICLE No: <temp.ari_vehicle_no>
PARENT STATUS: <temp.parent_status>
OWNER REP: <temp.owner_rep
TRANSFER REP: <temp.transfer_rep>
INQUIRY ID: <sv_inquiry_billing_materials.inquiry_id>
PRINT COUNT: <sv_inquiry_billing_materials.print_cnt>
CC NUMBER: <temp.cc_no>
CC STATUS: <temp.cc_status_desc>
CC STATUS DATE: <temp.cc_status_dt>
SERVICE/ID CARD: <sv_inquiry_billing_materials.service_card>
WEX FUEL CARD: <sv_inquiry_billing_materials.wex_card>
VOYAGER FUEL CARD: <sv_inquiry_billing_materials.voyager_card>
DATE REQUESTED: <sv_inquiry_billing_materials.request_dt>
TRACKING NO: <sv_inquiry_billing_materials.tracking_no>
COUPONS/PM SHEET: <sv_inquiry_billing_materials.coupon>
MAILING: <sv_inquiry_billing_materials.mail_method>
DATE SENT: <sv_inquiry_billing_materials.sent_dt>
3RD PARTY ACCT: <sv_inquiry_billing_materials.third_party_acct_no>
PHONE: <sv_inquiry_billing_materials.phone>
CONTACT: <sv_inquiry_billing_materials.contact>
ADDR LINE 1: <sv_inquiry_billing_materials.addr_1>
ADDR LINE 2: <sv_inquiry_billing_materials.addr_2>
ADDR LINE 3: <sv_inquiry_billing_materials.addr_3>
CITY: <sv_inquiry_billing_materials.addr_city>
ST/PR: <sv_inquiry_billing_materials.addr_state>
ZIP: <sv_inquiry_billing_materials.addr_zip>

Received by Planet Press:
{\rtf1\ansi\ansicpg1252\fromtext \fbidis \deff0{\fonttbl
{\f0\fswiss Arial;}
{\f1\fmodern Courier New;}
{\f2\fnil\fcharset2 Symbol;}
{\f3\fmodern\fcharset0 Courier New;}}
{\colortbl\red0\green0\blue0;\red0\green0\blue255;}
\uc1\pard\plain\deftab360 \f0\fs20 PRINT DATE: <temp.datetime_from>\par
CLIENT CODE: <temp.ari_lessee_code>\par
CLIENT VEH NO: <temp.ari_cli_veh_no>\par
VEHICLE No: <temp.ari_vehicle_no>\par
PARENT STATUS: <temp.parent_status>\par
OWNER REP: <temp.owner_rep\par
TRANSFER REP: <temp.transfer_rep>\par
INQUIRY ID: <sv_inquiry_billing_materials.inquiry_id>\par
PRINT COUNT: <sv_inquiry_billing_materials.print_cnt>\par
CC NUMBER: <temp.cc_no>\par
CC STATUS: <temp.cc_status_desc>\par
CC STATUS DATE: <temp.cc_status_dt>\par
SERVICE/ID CARD: <sv_inquiry_billing_materials.service_card>\par
WEX FUEL CARD: <sv_inquiry_billing_materials.wex_card>\par
VOYAGER FUEL CARD: <sv_inquiry_billing_materials.voyager_card>\par
DATE REQUESTED: <sv_inquiry_billing_materials.request_dt>\par
TRACKING NO: <sv_inquiry_billing_materials.tracking_no>\par
COUPONS/PM SHEET: <sv_inquiry_billing_materials.coupon>\par
MAILING: <sv_inquiry_billing_materials.mail_method>\par
DATE SENT: <sv_inquiry_billing_materials.sent_dt>\par
3RD PARTY ACCT: <sv_inquiry_billing_materials.third_party_acct_no>\par
PHONE: <sv_inquiry_billing_materials.phone>\par
CONTACT: <sv_inquiry_billing_materials.contact>\par
ADDR LINE 1: <sv_inquiry_billing_materials.addr_1>\par
ADDR LINE 2: <sv_inquiry_billing_materials.addr_2>\par
ADDR LINE 3: <sv_inquiry_billing_materials.addr_3>\par
CITY: <sv_inquiry_billing_materials.addr_city>\par
ST/PR: <sv_inquiry_billing_materials.addr_state>\par
ZIP: <sv_inquiry_billing_materials.addr_zip>\par
}

Top
#55152 - 08/10/17 04:08 PM Re: Email Input message body data question [Re: joersmith]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
Hi joersmith,

PlanetPress always captures the email's body "as-is", without altering it. It appears that the email's body in this case is RTF format instead of Plain Text, but it isn't PlanetPress that converted it to RTF. You might have to check your Outlook's options to make sure that it's sending in the right format.

One way to work around this would be to use attachments instead of the email's body, and include your text in an attached .txt file. It's probably safer that way too, because we really have no control over how an email's body will be formatted, it depends on the client that sends it and the way that the Outlook that receives it is configured. The email's attachment however should never be altered, so using the attachment should be safe no matter how you send the emails and from what client you use.

Regards,
Raphaƫl Lalonde-Lefebvre

Top