Capture Time/Date received info from Outlook

  • Thread starter Thread starter blackbox via OfficeKB.com
  • Start date Start date
B

blackbox via OfficeKB.com

I would like to capture Time/Date received info for certain emails that I
receive and populate them into certain cells. The emails have very specific
subject names, so there isn't much chance of them being confused with others
but a few also includes a date in the name.

example
"Futures for (06082007)File Has Been Sent."

to make it more difficult, Tuesday - Friday the emails are all received
between midnight and 5am but Monday's emails are received Saturday, Sunday,
and Monday morning.

if need be I can put a command button in the sheet to turn it off on Mondays.

I appreciate any help you can give.
 
also if possible I would like to get 2 numbers out of the body of one of the
emails.
They are all generated by another program so they are always formated exactly
the same.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate for "Friday last week until today" 6
Search specific column for a variable date 6
Shift Schedule Formula 1
How to write a query that add 1 working day to the date 2
Flex schedule for a work week. 2
Expressions in a table 1
EMPLOYEE WEEKLY SCHEDULE 6
Count the number of times the date is a Monday, Tuesday, etc 5

Back
Top