View Single Post
  #1  
Old November 15th 07, 04:37 PM posted to microsoft.public.outlook.program_vba
Steve
external usenet poster
 
Posts: 3
Default Please help me parse this email

I'm trying to find an easy way of parsing emails I'm cc'ed on for my
customer's orders.

I want to load parsed fields into an Online database (Access or
MySQL).
1. Search for new emails where subject = "Guru2008 Validation Code"
2. Parse email
3. Load data into database.


I bought a parsing program but since AT&T uses yahoo as the pop3
server
I can't get on - I think its due to the server using 995


Please help if you can
Thanks
Steve


Fields I want to capture are.

To email address (This is the customers email address)
Owner
Program
Validation Code
Validation Date
Serial



Email Subject "Guru2008 Validation Code"

***Email Body Start***

Please copy the Validation Code below

Owner = User
Program = Guru2008
Validation Date = Tuesday, November 13, 2007
Validation Code = Z570-U981-H344-O240
Serial = 1278E28

Thank You!
The Guru

***Email Body End***
Ads