|
|
How to find a date
Hy everybody,
I need an help, I have to find in my deault folder some emails recieved before a particular date, for example 1 Mars 2006. Set Myitem = Myitems.find(StrSearch) How should be String StrSearch? Thanks a lot Ivan |
How to find a date
See http://www.outlookcode.com/d/finddate.htm
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ivan" anonymous wrote in message ... Hy everybody, I need an help, I have to find in my deault folder some emails recieved before a particular date, for example 1 Mars 2006. Set Myitem = Myitems.find(StrSearch) How should be String StrSearch? Thanks a lot Ivan |
How to find a date
From the Object Browser help on Items.Restrict:
sFilter = "[LastModificationTime] '" & _ Format("1/15/99 3:30pm", "ddddd h:nn AMPM") & "'" Modify that to: sFilter = "[ReceivedTime] '" & Format("3/1/06 3:30pm", "ddddd h:nn AMPM") & "'" Don't use seconds in a filter. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Ivan" anonymous wrote in message ... Hy everybody, I need an help, I have to find in my deault folder some emails recieved before a particular date, for example 1 Mars 2006. Set Myitem = Myitems.find(StrSearch) How should be String StrSearch? Thanks a lot Ivan |
How to find a date
Thank you Sue,
I saw that page, but the example is about the calendar Folder, i'm working with Inbox folder, VBA returns me an error because it doesn't know the object [Start], maybe could be another name "Sue Mosher [MVP-Outlook]" ha scritto nel messaggio ... See http://www.outlookcode.com/d/finddate.htm -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ivan" anonymous wrote in message ... Hy everybody, I need an help, I have to find in my deault folder some emails recieved before a particular date, for example 1 Mars 2006. Set Myitem = Myitems.find(StrSearch) How should be String StrSearch? Thanks a lot Ivan |
How to find a date
That's the way!
Thank you Ken Have a nice week end "Ken Slovak - [MVP - Outlook]" ha scritto nel messaggio ... From the Object Browser help on Items.Restrict: sFilter = "[LastModificationTime] '" & _ Format("1/15/99 3:30pm", "ddddd h:nn AMPM") & "'" Modify that to: sFilter = "[ReceivedTime] '" & Format("3/1/06 3:30pm", "ddddd h:nn AMPM") & "'" Don't use seconds in a filter. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Ivan" anonymous wrote in message ... Hy everybody, I need an help, I have to find in my deault folder some emails recieved before a particular date, for example 1 Mars 2006. Set Myitem = Myitems.find(StrSearch) How should be String StrSearch? Thanks a lot Ivan |
How to find a date
The basic syntax, which Ken also gave you, applies to any date field.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ivan" anonymous wrote in message ... Thank you Sue, I saw that page, but the example is about the calendar Folder, i'm working with Inbox folder, VBA returns me an error because it doesn't know the object [Start], maybe could be another name "Sue Mosher [MVP-Outlook]" ha scritto nel messaggio ... See http://www.outlookcode.com/d/finddate.htm -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ivan" anonymous wrote in message ... Hy everybody, I need an help, I have to find in my deault folder some emails recieved before a particular date, for example 1 Mars 2006. Set Myitem = Myitems.find(StrSearch) How should be String StrSearch? Thanks a lot Ivan |
| All times are GMT +1. The time now is 11:27 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com