Need VBA to pull attachment from sub folder in outlook and update details in excel sheet column

[jacktc]

Dear experts

i need help on vba task assisgn to outlook take action to save all attachment to particular folder then update details in active workbook

for e.g

i have sub folder Name ("Sigma Metrics") where all mail with attachment save over there, i want move files to folder

i have sheet Run_outlook, where i want code to collect all document save to path and update details in Update_Tracker sheet

just update
Date:
Name:left(emailid,before@)
Email: who send mail
Subject: copy from email
File Name:
then no of sheet in workbook.

thanks and regards

 

[jacktc]

Any experts Help on this

 

[Marc L]

Hi, as this is an Excel forum …​

​

 

[jacktc]

Marc L u r here too

 

[Marc L]

As I did not work anymore with OutLook since around twenty years … ​

​