add custom date field to Outlook email

I am trying to tidy up my Outlook 2007 email processing as I currently have about 15000 emails in my deleted folder. What I would like to do is add a Date field to the list of emails in my inbox and have the ability to add my own date. That would enable me to allocate an "expiry Date" for each email before I delete it (i.e. move it to my deleted folder). Then every month I would simply run a job to delete all emails in my deleted folder where this date has past. Is this possible? How?
LVL 1
Rob4077Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Blue Street TechLast KnightCommented:
Hi Rob4077!

You can do this using flags: http://office.microsoft.com/en-us/outlook-help/add-or-remove-a-flag-for-follow-up-HA001234150.aspx?CTT=1 

You can set flags for specific dates and then create a rule to clear old ones. I actually setup a rule on every email inbound to be flagged by default that way I can "checkmark" each email after I have completed whatever is needed. Hope this helps. Let me know. Thanks!
0
Rob4077Author Commented:
Thanks for the suggestion diverseit but I am not sure that I can use flags the way I want.

When I have finished dealing with an incoming message I move it to the deleted folder. Some messages I want to keep there indefinitely whereas others I may be happy to permanently delete after a month, others a few months etc, depending on how likely I am to need to refer to them again.

At present I have a VBA routine that loops through everything in my deleted folder every now and then and applies my customised logic to decide if a message can be removed but the logoc is very hard to develop without the abiltiy to have a date set when I first move them to the deleted folder, hence the reason I have 15k messages there.

How do you suggest I use flags for that?
0
Blue Street TechLast KnightCommented:
Two options come to mind:
1.      Use flags to set custom dates for each msg: http://office.microsoft.com/en-us/outlook-help/add-or-remove-a-flag-for-follow-up-HA001234150.aspx?CTT=1
2.      Edit Expires Date in the properties of the desired msg.
Then to view either of these options in your Deleted Items,right-click on the column header e.g. Received, etc. and click Field Chooser. This will bring up a dialogue box where you can either select Due Date (for option #1) or Expires (for option #2). See attachment.
I believe both options I provided will give you what you are looking for. Let me know.

CustomDate.JPG
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Blue Street TechLast KnightCommented:
Option #1 is more efficient (less steps are involved) plus editing can be done line-by-line quickly. But Option #2 will actually strikethrough the entire msg greying it out, which is a nice visual affect but if the visuals don't matter as much I would stick with Option #1.
0
Rob4077Author Commented:
Thanks for that. Does Outlook give you the ability to redefine the flags. i.e. set the red flag to 3 months, the blue one to 6 months, etc?
0
Blue Street TechLast KnightCommented:
Yes, by default it allots for Today, Tomorrow, This Week, Next Week, No Date & Custom. You can also add reminders to them. Here is the link for adding color categories to flags: http://office.microsoft.com/en-us/outlook-help/add-a-color-category-to-a-flagged-item-HA010013776.aspx?CTT=3 
0
Rob4077Author Commented:
Thanks for all your help. Looks like my best alternative is one of the two options you explained earlier. Thanks again
0
Blue Street TechLast KnightCommented:
Thanks for the points. Glad I could help. Happy New Year!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.