I'd like Outlook VBA code that will parse the order confirmation emails I receive from Amazon, and save them to an Excel file (or CSV is fine too).
Attached is a sample text file with the full text of a sample Amazon order confirmation email. There are several items in the order -- I'd like a separate line for each.
I'll forward several more sample emails to the project winner, for their guidance.
This must work in Outlook 2007.
The following are the fields I'd like to pull off of it:
Date Email sent
IP address sent from
Thanks. Please let me know if you have any questions.
Deliverables (copied from rentacoder...):
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
20 freelancers are bidding on average $147 for this job
Let me do it for you for $100 within 3 days. I can even help you to retrieve order automatically from amazon then save buyer's information to Excel file for example. [url removed, login to view]
Dear Sir/Madam, We are well versed with your requirement. We have dealt with similar solutions in the past. A demo can be provided upon request. Regards Aanand
Hi, I have a web crawler in perl which can crawl the outlook 2007 for the mail and your desired content. Also the same can be updated in any DB by itself. Kindly waiting for your reply.