I have a web form that gets e-mailed to me every time it is completed. I want to be able to manipulate the data that is sent to me into another format that another program can use.
I have an email that looks something like this:
==============
1. First=John
2. Last=Doe
3. EMail=JohnDoe@gmail.com
4. Phone=555-1212
…etc but more complicated…
==============
I need to convert it, merging it with some other text, to something like:
==============
gen_sFirst=John
gen_sLast=Doe
gen_sEmail=JohnDoe@gmail.com
gen_sPhone=555-1212
…etc but more complicated…
==============
I then also need to be able to pull that email address out to send a reply email.
I looked at a number of programs including:
All these programs can parse email and output the fields into other programs or to a comma delimited text file. What none of them seem to be able to do is allow me to create a ‘merged’ text file.
I then found EPGateway. ($15). EPGateway allows you access POP3 accounts to extract data from the message header or message text for use with other applications. Personalized auto responses can be created and sent based on the extracted text and on filtered conditions.
It can create and send a reply email “form letter” that can be personalized from data from the incoming email. And it can output a “merged” text file combining the extracted fields with user text just like I need.
What is strange is that I cannot get it to ‘find’ the message text! It outputs all the header variables but the message text and any data extracted from it is just blank. I have been in an email discussion with the support group and they sent me a ‘fixed’ exe file but that did not fix the problem.
Hopefully we will get it figured out so I can use this program. If I cannot get it to work I will have to find some way to automatically convert the email to a plain text file when it comes in and just write a perl script to process the text file. Then I will have to figure out how to generate the reply email.