cancel
Showing results for 
Search instead for 
Did you mean: 

Extract table from e-mail body using MAPIex

xlxu001
Level 5
We are currently working on a process in which we are trying to poll work from e-mails to add to the queue by reading e-mails in which the e-mail body has somewhat of table format, but when the e-mail body is extracted to the data item it either comes out in plain text or if using MAPIex LATEST VERSION it comes out in extended code, but still the numbers don't show in the same table format nor following the headers appropriately.  Please see attached image of how the lines come in the e-mail.
Lourdes Urena Sr Solutions Engineering Grainger Panama Services Panama
2 REPLIES 2

John__Carter
Staff
Staff
Sounds like the data is CSV not really in a table. Parsing the message text should be straight forward - the values are separated by whitespace and the lines probably by CRLF.

xlxu001
Level 5
We ended up parsing the message text and using a bunch of Text formulas in order to get a specific range of data from the e-mail and have that data be our output from the object into the process in order to load the queue.
Lourdes Urena Sr Solutions Engineering Grainger Panama Services Panama