Hi,Originally Posted by korgul
![]()
Great it's working now! You're most welcome!![]()
I knew it had to be something in the environment! "Short Date" over here returns : "05-27-2005" so that's ok for a file path!
This has everything to do with regional and country settings in Control Panel. Totally overlooked this stupid mistake!
O wel good to see you noticed youreself that it's not allowed to have a: "\" or a "/" in the wrong place in a filepath!
Can I make one suggestion:
I would make this change:
sDate = Format$(oMail.ReceivedTime, "mm-dd-yyyy")
This formats as: 05-27-2005 and this if better if you're using this for a longer period than a year otherwise you run out of folders!!!!
So tell me....How much time does my macro save you each day!![]()
Enjoy!![]()
Ps..please don't forget to mark your thread solved!