Question for the programmers

1 replies
I have about 3,700 orders over the past 2 years in my outlook express box for my online business (photo ID products) and what I need is to get specific data from these messages in a csv file, such as name, email, tel. number, order amount so I can get into this whole email marketing thing. I'm more of a direct marketer, we do physical brochures and catalogs but I'm now looking to cost cut by sending e-brochures. Here is the format of these emails. I'd be willing to pay a hundred for the answer to my problem that works. I looked for an answer online but all I see are scripts and I don't know what to do because I know nothing about programming.

Order Total: $314
Order Number: 1238378526 -

Please do not respond to this e-mail. It was generated by an automated system.

Order Number: 1238378526-20896121250
Date: 3/29/2009 7:02:06 PM MST

Thank you for your order! This is a confirmation that your order has been placed with ID SUPPLY. (Processing of your payment and shipping is done Monday thru Friday between 8am and 5pm MST.)

If your order is over $250 and you require expedited shipping via UPS Next Day, 2nd Day, or 3 Day Services a representative will call you with the actual shipping charges. (Rates vary based on the weight of the items ordered)

Bill To:
Doug Birney
#18 296 Broadway ave
R3C 0R8
(email address was here but I had to delete cuz its my first post)
Email me the paypal invoice so i can send the funds for this order. I have picked second day air

Qnty Item Description Price Extended
500 CC30CH 30 Mil 60/40 PVC/Polyester $0.26 $130.00
with 1/2 inch HiCo Mag Stripe
1 84011 YMCK: HDP Full-color ribbon $184.00 $184.00
with resin black panel �
500 images (CR-80)
Sub Total: $314.00
Taxes: $0.00
UPS 2 Day Air Shipping: $0.00
Total: $314.00
#programmers #question
  • Profile picture of the author CliveG
    This is relatively straightforward. Each email can be exported from Outlook Express as an eml file. A script (if it was me I would use Perl) could then run through the files and extract the information to a csv file.

    You can probably get a script done on one of the online coding services, for example elance, for about $50. Be very specific about the information that you require. If you only need name and email address the script need be only about 20 lines long and could be even cheaper.
    {{ DiscussionBoard.errors[1025835].message }}

Trending Topics