I know this is the excel forum, but you guys don't have a forum for Outlook, soooooo.......
Working on automating saving/printing of invoices for one of our AP reps (roughly 700 miles away, so support won't be simple).
Ive got the code that saves and prints the attachments for the selected messages to a specified location. She'd like it to automatically sort the saved file to a folder matching the vendor's @domain.com email. I'm trying to think of the best way to accomplish that, since obviously I can't use an excel lookup table. Should I just build a two-dimensional array (to match the @domain.com with the folder) and have her contact me if she needs to add new vendors? Or is there a better way, such that she can add or change entries?
Working on automating saving/printing of invoices for one of our AP reps (roughly 700 miles away, so support won't be simple).
Ive got the code that saves and prints the attachments for the selected messages to a specified location. She'd like it to automatically sort the saved file to a folder matching the vendor's @domain.com email. I'm trying to think of the best way to accomplish that, since obviously I can't use an excel lookup table. Should I just build a two-dimensional array (to match the @domain.com with the folder) and have her contact me if she needs to add new vendors? Or is there a better way, such that she can add or change entries?
