I have numerous emails In Outlook and all have the same subject line and pretty much all of them have 20 or so lines within them. Is there anyway to pull certain data out of each email and into an Excel spreadsheet in two columns?
I basically want to capture the product number and the entry for the system. Is there anyway to do this?
Example Email
Subject: Product Order Information
Action to take: Order this Product
Product number: 60610 <--------------Capture this data
Type: MTL
Type Number: 1000
Type PIN: 001
Type Weight: 12
Person Ordering Product: Smith
Person Email: smith@
Type Part:
Type Title: Metals
Type Level: 2
Manufacturer: Acme Industries
Contact: 555-555-5555
Location: NYC, NY
Required or Recommended: Required
Comments:
Action Add product
Entry for System: Metals for processing ~ More information (Click for prices, inventory, etc. if applicable) <-------------Capture this data
Bookmarks