Export E-mail

[Guest]

Hi! I'm trying to export a list of all e-mails from a particular folder to
Excel with "To" "From" "Subject" "Date Sent" "Date Received" ... I'm getting
the text portions, but so far haven't been able to get the date fields. Is
there a way to get them?
Thanks!

 

[jaf]

Hi,
Incase you use the date in a filename, you have to remove the slashes/colons
as they are illegal characters.

MyRecDate = Format(objSelection.Item(i).ReceivedTime, " YYYYMMDD
HHmmss.sss")
MySentDate = Format(objSelection.Item(i).SentOn, " YYYYMMDD HHmmss.sss")

 

[Guest]

Hi, John. Since I'm starting from "baby steps", I'm not sure if your reply
is helpful or not.
I'm just using the File/Import or Export/Export to Excel menu options in
Outlook. When I do that, I don't get any date fields. Is there an
easier/better way to do what I want? I'm just trying to get a list of e-mail
from a particular Outlook folder to send to a lawyer for a lawsuit our
company is involved with. Hopefully, it's just a one-time thing....
Thanks for your help.
Cindy

 

[jaf]

Hi Cindy,
Sorry but you can't get the date & time with a file>import & export.
You would need a macro.