+ Start a Discussion
qraishqraish 

Table in Email to Case Description

In an email to case set up, the body of the email is set to be displayed as description in the case in salesforce.

 

This goes ugly when an email consist of a table and the data in table comes off something like this in Case Description for e.g.

 

Library Complaints Issue Information: Issue Date Location Issue Description Vandalism Aug 30 1969 12:00:00:000AM 4th floor Too many people 4th floor lobby Issuer Information: Student Number Title First Name Type StudentID22222222����������

 

Can we parse out the information on the table of email's body in some sensible manner in Case description??

 

Any insights towards the solution will be greatly appreciated.

 

Thank you!!

Sonam_SFDCSonam_SFDC

Qraish,

 

It would not be possible to parse the body of the incoming email as the email to case service address simply forwards email to sf and creates case

 

The reason why the tables are not displaying properly on your records because the format of the description field is Long Text Area only. The format of the field shoud be Rich Text for it to capture and display the table but this is a standard field and we will not be able to convert it.

 

If this is a must then you can probably create a custom email service which can be used to create cases in salesforce and implement the functionality to parse tables in a proper format.

qraishqraish

Thank you very much for your insights Sonam!!