Hi All,
I receive several reports daily which I want to automatically rename and save into a folder where Access will read from when I open my access file. This way it automatically gives me the latest information from those files.
Example: I receive a shipping, booking, opportunity, and backlog report all in separate emails in an attachment in excel format.
Each with a unique extension like booking12282018.xls but the beginning is always the same i.e. booking. I have a rule in Outlook that files them in a folder within outlook but I am curious if there is a way to add a file to the rule so that it automatically renames and saves to my c:\\accessfiles folder. I would like it named booking.xls when it is saved.
I realize this is an Access forum and I can't be the only one receiving their data this way. I have found code to download all attachments in Outlook but that is not helpful. I need to rename and save upon receipt.
Thanks for your help.
Razzbarry
I receive several reports daily which I want to automatically rename and save into a folder where Access will read from when I open my access file. This way it automatically gives me the latest information from those files.
Example: I receive a shipping, booking, opportunity, and backlog report all in separate emails in an attachment in excel format.
Each with a unique extension like booking12282018.xls but the beginning is always the same i.e. booking. I have a rule in Outlook that files them in a folder within outlook but I am curious if there is a way to add a file to the rule so that it automatically renames and saves to my c:\\accessfiles folder. I would like it named booking.xls when it is saved.
I realize this is an Access forum and I can't be the only one receiving their data this way. I have found code to download all attachments in Outlook but that is not helpful. I need to rename and save upon receipt.
Thanks for your help.
Razzbarry