Hi,
I would like to export data from an Excel file attached to an email... to another Excel file... and I would like to do it (if possible) by mass exporting all emails within a specific Outlook folder.
The 2nd half of the code (the exporting from one Excel file to another... I've got down). What I don't have is how to open up the Excel file that is attached to an email in a folder...
Currently, the 2nd half of the code only works when the exporting file is open, so I assume that provided that I can have all of the attached Excel files be opened in order, then the 2nd half of the code can work...
Is this possible? I've looked on the Internet and have not seen this before... it may not exist... I can get around with VBA codes and Excel, but I'm very much a novice.
I would like to export data from an Excel file attached to an email... to another Excel file... and I would like to do it (if possible) by mass exporting all emails within a specific Outlook folder.
The 2nd half of the code (the exporting from one Excel file to another... I've got down). What I don't have is how to open up the Excel file that is attached to an email in a folder...
Currently, the 2nd half of the code only works when the exporting file is open, so I assume that provided that I can have all of the attached Excel files be opened in order, then the 2nd half of the code can work...
Is this possible? I've looked on the Internet and have not seen this before... it may not exist... I can get around with VBA codes and Excel, but I'm very much a novice.
