We get emails sent to us every day when orders are shipped. We need a way to extract the tracking number and the order number so it dups it in an csv file and our system imports it. This needs to run every hour and the file need to be over written every hour so we don't get dup tracking infomation.
This is an example of how we get this info
Your Ref: 104386
Order No.: 1720208-0
Order Date: 04/09/2013
Carrier: ExpressPak NextDay
Taken By: WEB
Cover: PLAIN COVER
This script needs to export Order No.: 1720208-0 which is the tracking number but the -0 need to be remove and the order number which needs to be in a another column is Your Ref: 104386
Look forward to your comments
16 freelancers are bidding on average £31 for this job
I will make the utility in vb.net,it will be a timer based and execute automatically every 60 mins. Please provide details as whether the emails will be in outlook folder or some other file.
Hi This is Piyush Patel I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM
Hi, I am expert in this kind of work and already completed more than 200 projects. Please look at my feedback to know more work about my work. Waiting for more details along with positive reply. tks.
I can do this easily and have many scripts running on my own MS outlook now that does similar work. You can see my past work and reviews that show my VBA knowledge.