I get an email from Credit Card Merchant Service when product is sold.
The email i get is in the following format:
Order Number: INV133-042935082509
PONumber:
Time: Tue Aug 25 16:29:36 2009
cc: mastercard
shipped: Y
shiptype:
user id:
name: PDC Retrievals - Flushing
company:
addr1: Long Term Care Insurance
addr2:
city:
zip: 11367
state:
country: US
shipname: PDC Retrievals - Flushing
shipaddr1: Long Term Care Insurance
shipaddr2:
shipcity:
shipzip: 11367
shipstate:
shipcountry: US
email:
phone:
fax:
Reference:
Comments:
Subtotal: $6.65
Tax: $0.00
I need to create a excel sheet (data base) for all the emails i get.
These emails are stored in a specific folder in Outlook.
Let me know if you have any questions.
Thank you and help is always greatly appreciated.
Riz Momin
Bookmarks