How to update file names when the file names contain specific string referenced from an excel table?

[weijianhk]

Hi Guys,

I need some help here please!. I have created a fully functional outlook macro, that downloads Outlook attachments to OneDrive specified folder. So the macro would update the file name with the email domain and month/year e.g. from original attachment name "Invoice_GBR_Z-GRX_2019_07.pdf" it becomes "comfone.com_08-2019___Invoice_GBR_Z-GRX_2019_07.pdf" after executing the macro.

However, I would like the macro to also have the ability to compare against a static excel table called Table.xls on my desktop (2 columns where column A contain the email domain name, and column B containing its respective company code), wherein if the excel cell contains "comfone.com", then its corresponding company code say 0001 would then be appended to the file name so the file name gets updated to "0001_comfone.com_08-2019___Invoice_GBR_Z-GRX_2019_07.pdf"

Is there any expert who could lend a hand and assist me please? I'm struggling quite a fair bit not knowing how to reference to an excel table from my outlook vba. Thanks a ton!

 

[Fluff]

Duplicate How to update file names when the file names contain specific string referenced from a table?

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).