Hi,
Is it possible to amend the below code so that when it saves the attachment it changes the file name. Currently it keeps overwriting files instead of creating and renaming new ones.
It would also be perfect if the code could rename each file based on data in a cell.
Please Login or Register to view this content.
The following line in your code specifies the full path name for where the file is to be saved:
You can make the filename anything you want, just change the part to the right of the "&". If you want the filename to be taken from a cell, such as A1 on Sheet1, using the same extension as the attachment:Please Login or Register to view this content.
For example, if you have "Test" in A1 and the attachment is "Foo.xlsx" then the result will be "Test.xlsx".Please Login or Register to view this content.
I have compiled but not tested this since it requires some setup with Outlook specific to your situation.
Thanks for the help. I copied this code, but I get the error 'Invalid procedure call or argument'. Also I changed "A1" to "D4" for my purposes.
Any ideas?Please Login or Register to view this content.
My mistake, fname was in my test code and not the correct thing to use in your code. This line will work:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks