Hi,
I don't know if this is possible, but reading around this forum I am hopeful!
We have 1000's of faxes stored as Emails, filed in a folder in Outlook, with the same subject but slightly different attachment names
We will now be filing the attachments instead of the messages, as this will store them with the filename in the subject field (possible to search through manually)
I can create a quick sheet using vlookup to display the correct filename but I need to know if VBA can be used to instigate Outlook to either open or filter down to the correct message
The items would be in a subfolder from the main Inbox
A sample filename would be ATT300206.tif
Another alternative is to save the message with order numbers as the subject, fairly simple to copy and paste in Outlook's "Find..." but I still want to find a way of automating the process, as the sheet already contains several lookup functions. Preferably with one click on a spreadsheet macro!
Any help would be great!!
I don't know if this is possible, but reading around this forum I am hopeful!
We have 1000's of faxes stored as Emails, filed in a folder in Outlook, with the same subject but slightly different attachment names
We will now be filing the attachments instead of the messages, as this will store them with the filename in the subject field (possible to search through manually)
I can create a quick sheet using vlookup to display the correct filename but I need to know if VBA can be used to instigate Outlook to either open or filter down to the correct message
The items would be in a subfolder from the main Inbox
A sample filename would be ATT300206.tif
Another alternative is to save the message with order numbers as the subject, fairly simple to copy and paste in Outlook's "Find..." but I still want to find a way of automating the process, as the sheet already contains several lookup functions. Preferably with one click on a spreadsheet macro!
Any help would be great!!