PC Review


Reply
Thread Tools Rate Thread

Date range for Outlook - automatically select previous 2 months

 
 
StevieToo
Guest
Posts: n/a
 
      9th Nov 2009

At work we have had the 'autoarchive' dismantled. but I want to run a 'find'
or macro that automatically selects completed flags over a certain age - and
then I can put them in the bin or files them somewhere off the server
(automatically with a bit of luck.
I have tried 'Advanced Find' 'Advanced' Recieved, on or before...
AND THEN the hard bit, is it (NOW)-60 Now(-60) Today-60... or what?
Stevie K
 
Reply With Quote
 
 
 
 
Roady [MVP]
Guest
Posts: n/a
 
      9th Nov 2009
Field: Received
Condition: between
Value: Today and 2 months ago

For more about doing queries based on time and dates see;
http://www.msoutlook.info/question/301
http://www.msoutlook.info/question/321
http://www.msoutlook.info/question/344

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

http://www.msoutlook.info/
Real World Questions, Real World Answers

-----

"StevieToo" <(E-Mail Removed)> wrote in message
news:1D33FAC5-EB88-47E8-B461-(E-Mail Removed)...
> At work we have had the 'autoarchive' dismantled. but I want to run a
> 'find'
> or macro that automatically selects completed flags over a certain age -
> and
> then I can put them in the bin or files them somewhere off the server
> (automatically with a bit of luck.
> I have tried 'Advanced Find' 'Advanced' Recieved, on or before...
> AND THEN the hard bit, is it (NOW)-60 Now(-60) Today-60... or what?
> Stevie K


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many months between two date range Talladega Microsoft Excel Worksheet Functions 10 25th Mar 2009 01:49 PM
How do I select 13 months from a data range for charts =?Utf-8?B?bWFyZw==?= Microsoft Excel Charting 3 14th Mar 2007 06:30 AM
Year to Date and Previous Months =?Utf-8?B?QnJhbmRvbg==?= Microsoft Access Reports 1 16th Aug 2005 08:32 PM
How do you get a date range to display months? =?Utf-8?B?VGFtbXk=?= Microsoft Access Reports 3 8th Jun 2004 03:53 AM
Adding months to a previous date Sharon Microsoft Access Form Coding 2 5th Nov 2003 05:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:26 PM.