csv - Selecting/Forwarding Emails in Outlook based on Subject Criteria (text file) -

csv - Selecting/Forwarding Emails in Outlook based on Subject Criteria (text file) -

using outlook 2010 , .csv text file.

i have list of ticket numbers work daily. 1 time deal tickets have forwards associated email 3rd party. conveniently, utilize unique ticket ids (6 digit numbers) on our tickets , have programme fills text file (well, .csv) list of tickets work every day. i'm trying find way have outlook read file , search folder emails ticket id in subject line , forwards them.

essentially want outlook read first line in .csv, locate matching email , forwards it. rinse , repeat until file read way through.

so, assuming want create vba macro in outlook, here's basic architecture:

set reference microsoft office excel object model library use excel vba open .csv editing search emails in outlook using info you've acquired spreadsheet

that should started!

email csv outlook