Yes trying to get those into windows explorer details. You assisted me in getting them exported to a file with a macro a while back and it works great. But I found that windows search works well with regular emails instead of using the macro but the problem is it will not save multiple emails...
I have a macro to export an email to a folder. It saves the date, time, from and subject line as the file name. How can I get this to save the email as Name= date and time, Author= sender and Subject= Subject.
Well that was the issue. It works great. Now I have to play with it and see if I can get it to work on email directories. I have couple hundred with thousands of emails to output to file.
Thank you for your time on this.
Not sure if its the version I am running but it does not like this line:
name = Format(mItem.ReceivedTime, "MMDDYYYY HHMM") & " " & mItem.Sender & " " & name
Run time error '438'
Object doesn't support this property or method.
maybe the mItem.Sender is suppose to be...
I had to strip some code as it would not let me post some where around 4000 characters. Here is the code I stripped, it belongs at the (removed code )
' Cleanse illegal characters from subject... :/|*?<>" etc or sharepoint wont have it!
name = Replace(name, "<", "(")
having issues at this part of the macro.
I wish to have the format show up as
MMDDYYYY HHMM Name Subject.msg
(name would be who sent email as showing in Outlook)
I end up getting:
MMDDYYYYY HHMM AMD Subject.msg
Here is the code I found that gets me almost to the right setup...