Hi all,

This is my first post so excuse my stupidity with vba.

I found a code online which worked perfectly to automatically save all the excel attachments within a particular sub-folder of my inbox into a location on our share drive. I receive daily emails relating to the same thing and each file is named with a bunch of numbers. I need the macro to save the email renaming the file name to the email subject e.g. the email subject is "daily sales". I therefore want the file name to be "daily sales". I understand that this will therefore overwrite the file with the latest one, which is what I want.

Could you please help me. I've googled for hours and found that I need to add in save_name = objmail.subject somewhere but I dont understand where to add this and every option I've tried comes back with an error.

The code I'm using in the first place is:
Please Login or Register  to view this content.