176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

VBA - Outlook / Excel
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Mar 20, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I need a macro that extracts details from the body of an email, into an excel spreadsheet. Certain details from an email need to be pulled through to a spreadsheet from the body. Each line of data from the email needs to be pulled through into a new column of the spread sheet. The emails look similar to the below message. I need to extract Order Date, Shipment Date, Quantity, Subtotal, Shipping, and Total.

Thanks


Dear Customer,

Greetings from Amazon.co.uk,

We are writing to let you know that the following items have been sent
to:

[ ]
using Royal Mail.

For more information about delivery estimates and any open orders, please visit:   [obscured]  /your-account

Your order #202-9473348-6310740 (received March 15, 2012)
-------------------------------------------------------------------------
Qty Item Price Delivery Subtotal

-------------------------------------------------------------------------

Amazon.co.uk items (Sold by Amazon EU S.a.r.L.):

5 All The Boys Love Mandy La...

Sign in or Register to see more

Desired Skills
Visual Basic
Job ID: 29384436
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Ukraine  |  
I have been crafting code since 2000. Experience: C++ - 9 years, C# - 5 years, PHP/MySQL/HTML/JavaScript/AJAX/CSS - 5 years. Very good English...
4
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 29500851  |  Submitted: Mar 26, 2012 16:40 ET 
Proposal SEALED

 India  |  
VB/ SQL programmer over more than 12years.
1
  |  
 3.2   |  Private   |  0 Jobs
Bid ID: 29464950  |  Submitted: Mar 24, 2012 16:21 ET 
Proposal SEALED

 Greece  |  
Native Greek professional translator (English to Greek). Experience: more than 20 years cooperator of M. Giourdas Publications (Greece),...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29438907  |  Submitted: Mar 23, 2012 04:13 ET 
Proposal SEALED

 Serbia  |  
Professional Service with more than 600 completed projects.
8
  |  
 5.0   |  Private   |  31 Jobs
Bid ID: 29429538  |  Submitted: Mar 22, 2012 15:26 ET 
Proposal SEALED

 Moldova, Republic Of  |  
Experienced MS Office Add-in developer (using VBA), with great knowledge of MS Office suite versions 2003, 2007 and 2010, that can create lot of...
4
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 29427304  |  Submitted: Mar 22, 2012 13:34 ET 
Proposal SEALED

 India  |  
Hi I am an experienced software professional and having experience of more than 8 years in Database technologies & software testing I am...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29420152  |  Submitted: Mar 22, 2012 07:23 ET 
Proposal SEALED

 Egypt  |  
I am fully qualified to do the following: 1- Excel, Word and outlook scrips and programs(VBA macros). 2- New excel Functions creation. 3-...
6
  |  
 4.9   |  Private   |  17 Jobs
Bid ID: 29400089  |  Submitted: Mar 21, 2012 10:33 ET 
Proposal SEALED

 India  |  
Expert programmer with multiple skills... 1. Office Automation - MS Excel Expert with deep knowledge of VBA/Macros and Formulas. Extensive...
8
  |  
 4.9   |  Private   |  31 Jobs
Bid ID: 29399997  |  Submitted: Mar 21, 2012 10:29 ET 
Proposal SEALED

 Bangladesh  |  
I Am Mainly A Expert Software Developer, I can give your soft as per your requirement
7
  |  
 5.0   |  Private   |  11 Jobs
Bid ID: 29389776  |  Submitted: Mar 21, 2012 00:04 ET 
Proposal SEALED

 United States  |  
I have 16+ years of experience in various areas of system analysis, design and development in all Microsoft technologies spanning all tiers -...
5
  |  
 4.9   |  Private   |  17 Jobs
Bid ID: 29387951  |  Submitted: Mar 20, 2012 21:47 ET 
Proposal SEALED

 India  |  
As a Professional Developer with .NET, VSTO, Excel, Outlook and HTML5, CSS and jQuery programming with over 6+ years of experience, I can help you...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29386466  |  Submitted: Mar 20, 2012 19:38 ET 
Proposal SEALED

Bogdan S.      
Bogdan S.'s identity has been verified.  Learn More
 Romania  |  
10+ years of experience as a software developer
7
  |  
 5.0   |  Private   |  13 Jobs
Bid ID: 29385966  |  Submitted: Mar 20, 2012 18:58 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »