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??

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??

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??

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??

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??

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??