I have done sending emails automatically in code - very easy - however now I need to do something i'm sure can be done but don't know how.
I will have numerous daily emails sent to a specific folder in outlook. I need to automate in a button to go thru each email in this specific outlook folder - grab the subject line (which is the "Real" file name) and then download that xls file to a folder on my c drive and rename that file with the subject line, then repeat this for every file in the folder until done.
If possible i would also like to move the email to another outlook folder so I know whats been processed and whats new but if that's not possible then i can live with that. Any ideas or help with that kind of code?
So you know the reason I have to rename the files is because every file that comes in has the same name to it and the subject line is really what the file name is and I dont want to overwrite the file as it downloads to the c drive folder.