I have some code that allows a user to select multiple messages, then automatically save all attachments in those messages, and print them out. What they would like to do is be automatically be sorted to a specific folder based on the sender's domain name (its for an Accounts Payable rep).

What would be the most easily supportable way of looking up the save-to folder? Obviously I could make a hard-coded two-dimensional array and do it that way, but I really don't want to have to crack open the code every time she needs to add or change something.

Is there any way she could maintain a table with that information? Is there a way to call vlookup from outlook so she could keep it in a spreadsheet?