Steph
Yes, you can have two emails with same received time. Of the 1,406 emails
in my Junk folder, two pair had the exact same received time. That's pretty
low odds, but I don't know if it's worth it. If you'd like to use the
ReceivedTime for other reasons, then you could pretty easily append a number
to the end of the file name if it already exists.
Each message has a unique ID, but it's like 27 characters long and pretty
unintelligible. Let me know if you need more help with any of these
options.
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"Steph" wrote in message
...
Sorry Dick, my previous post shoud have read But I admit I'm NOT real good
at this stuff!!!!!! Stressing the word NOT!!
Sorry....that typo made me sound like a know-it-all pompous ass!!
"Steph" wrote in message
...
Thanks Dick. I checked it out, but admit I'm real good at this stuff.
Recall that my procedure saves all attachments to a specific folder (not
an outlook folder). I have a counter in place and am renaming the files
arbitrarily based on that. Would it be easy to save the filename as the
ReceivedTime? I guess the one pre-req I should have asked is Can 2
e-mails arrive at the exact same time, and therefore have the exact same
ReceivedTime?
Thanks Dick!!!!!!!!!!!!!!
"Dick Kusleika" wrote in
message
...
As a matter of fact I do. I should have included that in my answer,
sorry
about that.
http://www.dicks-clicks.com/excel/olRetrieving.htm
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"Jack" wrote in message
...
Thanks Dick. Do you know of any sample syntax?
"Dick Kusleika" wrote in
message
...
Steph
Use the ReceivedTime property of the MailItem object.
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"Steph" wrote in message
...
Hi. Every week I run a procedure that saves the attachments from
a
bunch
of
e-mails with a single folder to 1 large file. My question is
this -
can
I
somehow also, for each file, pull in the timestamp from when the
e-mail
was
received??