This is a continuation of http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28143009.html
The function correctly imports the email address of the sender into Col D but I also need to extract the email address from the csv or xls file and insert that into Col D - IF - the email in the file is different from the sender's email address.
So, if the sender's email address is firstname.lastname@example.org and the email address in the csv or xls file is also email@example.com then import firstname.lastname@example.org into Col D.
However, if the email address in the csv or xls file is different, say email@example.com then import into Col D: firstname.lastname@example.org / email@example.com
And each row in the csv or xls file is a different record (if there is more than one) and therefore would be entered into Applicant Status separately.