I've been asked to create a tracking template to track every step of the process for formal inquiries that go into a Outlook inbox.
The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who;
Inquiries
Oct 25 2019 - Mr. X - topic (so in this folder would be a copy of the initial Outlook request)
Oct 25 2019 - Mr. X - topic
Oct 25 2019 - Ms. Y - topic
To track responses, I'm wondering if there's any VBA way to get the spreadsheet file to automatically "populate" the first few rows with the details from these folders--ie, whenever the Excel spreadsheet is opened, it automatically looks for any new subfolders that have been added, and then pulls the metadata (or even just the title of the subfolder) into the first few rows, with Date, Request From, and topic.
Is there a way to do this?
The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who;
Inquiries
Oct 25 2019 - Mr. X - topic (so in this folder would be a copy of the initial Outlook request)
Oct 25 2019 - Mr. X - topic
Oct 25 2019 - Ms. Y - topic
To track responses, I'm wondering if there's any VBA way to get the spreadsheet file to automatically "populate" the first few rows with the details from these folders--ie, whenever the Excel spreadsheet is opened, it automatically looks for any new subfolders that have been added, and then pulls the metadata (or even just the title of the subfolder) into the first few rows, with Date, Request From, and topic.
Is there a way to do this?
