Cancelled

Outlook VBA - Parse Amazon Order Confirmation Emails

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

Delivered-To

From

IP address sent from

Billing Name

billing Street

billing city

billing state

billing zip

billing country

order number

shipping method

subtotal

s&h

tax

gift cards

total

delivery estimate

Item Title

Sold by

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).

Skills: Visual Basic, Web Scraping

See more: order confirmation email sample, form outlook vba, vba work, vba with, vba coder hire, please let know questions, hire vba coder, amazon vba excel, amazon c, state legal, order confirmation email outlook, order outlook emails, amazon order confirmation, vba for, me vba, in vba, vba code excel, vba excel, tax law, rentacoder site, outlook visual basic, outlook email, order, gpl, cards billing

About the Employer:
( 94 reviews ) Golden Valley, United States

Project ID: #559943

20 freelancers are bidding on average $147 for this job

srinichal

Looking forward to take up the task

$160 USD in 3 days
(49 Reviews)
6.3
svet63

VBA developer since 1997. Can do. Regards, Svet.

$175 USD in 5 days
(40 Reviews)
5.9
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

$175 USD in 5 days
(54 Reviews)
5.9
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

$100 USD in 2 days
(13 Reviews)
4.1
refractocd

Please refer to PM

$70 USD in 3 days
(12 Reviews)
3.9
johnsinit

Dear sweetcow! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$185 USD in 3 days
(9 Reviews)
3.8
sumeet00

Hi, I guess I have worked with you before. Check PM for more. Thanks, Sumeet.

$90 USD in 5 days
(3 Reviews)
3.1
spiritdevss

Having worked on various parser modules within various add-ins for MS Outlook for information extracting from mime header and from mime body or mime parts based on the various requirements of the client by providing th More

$150 USD in 7 days
(2 Reviews)
2.5
lalchetian

Hello, I have coded a example for you to demonstrate my skill please refer pmb

$95 USD in 3 days
(1 Review)
1.6
JunhuiCHEN

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. http://S.SimplestAccess.Com/

$100 USD in 5 days
(0 Reviews)
0.0
rcreely

Have done something very similar before.

$65 USD in 2 days
(0 Reviews)
0.0
freelancemstech

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

$199 USD in 9 days
(0 Reviews)
0.0
wrightd9171

Hi - I've been coding for 20+ years. I've been doing Visual Basic for over 10 years. I have extensive experience with using Visual Basic to read Outlook emails and parse them for relevant data like what you want More

$200 USD in 5 days
(0 Reviews)
0.0
subeersign

please check PMB.

$200 USD in 7 days
(0 Reviews)
0.0
kstandiford

After reviewing your project information and requirements, it is a perfect fit. With over twenty year experience and skilled in over 30 different programming languages. We have the ability to deliver world class, SDI, More

$250 USD in 3 days
(0 Reviews)
0.0
dhaskarthick

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.

$150 USD in 7 days
(0 Reviews)
0.0
guruplus

Hi Please refer my PRIVATE MESSAGE Thanks

$130 USD in 3 days
(0 Reviews)
0.0
KumarNigam

The project sounds interesting, I have done the VBA with outlook. This will be easy for me to complete. Thanks

$100 USD in 2 days
(0 Reviews)
0.0
SeniorVBAcoder

By way of introduction, I am a US based developer with extensive experience building successful Outlook 'New Mail' event capture applications. These system look for new mail from a specific sender and subject line and More

$200 USD in 5 days
(0 Reviews)
0.0
prasanthmohanan

Hi , I have good Experience in VBA , Hope to work with you

$140 USD in 5 days
(0 Reviews)
0.0