I am trying to automate a system I have now about emails I get from a vendors about shipping orders .I am trying to do up a macro which will automatically take the specific fields and content from the message and update a spreadsheet I have ,as soon as the email comes in.
I have attached a copy of the email and the Fields I need updated
SENT: which goes under column 'A' of the spreadsheet (date),
Subject: which goes under column 'D' of the spreadsheet
MESSAGE body : (which only the numeric entries are taken ORDER# XXX-XXXXXX format) goes into Column 'B'
Most of these orders come from vendors who use mobile devices so I cant have them send a specific form. but the format they send the email always remains the same (that's why only numeric entries are picked from the message body)
Bookmarks