Newbies illbe Posted February 9, 2005 Newbies Posted February 9, 2005 Hi, This is a fairly simple question (for all of you), but one I need an answer for. I have several hundred e-mails I'd like to capture into FM. I need to parse unneeded lines and put my field info into FM fields. Here is a sample below of one of the e-mails. Any help will be appreciated. Please excuse my newbeeness. The following is the contents of a form submitted on 20-Jan-05 at 03:11 PM: FIRST_NAME: neville LAST_NAME: ribeiro ADDRESS: 4254 renoak ADDRESS2: CITY: mississauga STATE: ontario ZIP: l5c 4k1 COUNTRY: Canada PHONE: 905 275 8285 FAX: EMAIL: [email protected] ENG_MAKE: o320 h2ad ENG_MODEL: ENG_SERIAL: AIR_MAKE: AIR_MODEL: AIR_SERIAL: AIR_N: COMMENTS: have a N model 1980 with doing a rebuild don't have a core would like a price on an stc'd d2j convert or up grade to a 180hp o360 engine. coming down to fulton newyork on tuesday. would it be convenient to tour your facality . also like a list of you stc's SUBMIT_BUT2: Submit EMAILTO: [email protected],[email protected],[email protected] EMAILFROM: [email protected] EMAILSUBJECT: DeltaHawk EMAILCONFIRM: http://www.pennyanaero.com/thanks.asp
Lee Smith Posted February 9, 2005 Posted February 9, 2005 Hi Tom, and welcome to the Forum. Use the "Search" (found at the top of each page) to perform a "Search", in "All Forums", using the "Keywords" and the + as follows: +Extract +Email +Address Eliminate the 1 in "Weeks" and it will return 34 hits. Included in the Hits, are even a couple of sample files on how to do this. Check out the one by CobaltSky, because if I remember rightly, it does exactly what you are asking. HTH Lee
Newbies illbe Posted February 11, 2005 Author Newbies Posted February 11, 2005 Thank you Lee, I'm afraid I need to up my chops in FM scripting as most of the replys were over my head. I did download POP3it however and I'll try using it to parse the info I need from the e-mails. My only problem is that it hangs when I try to configure it (rotating beach ball). I'll keep crusin' the forum.
Recommended Posts
This topic is 7228 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now