Using Journal Create Date in Code

  • Thread starter Thread starter Brad Swindell
  • Start date Start date
B

Brad Swindell

I have a system to download Outlook Contacts and Journal Entries to
Access using VBA. I maintain a last download date in a table, and
want to capture Journal Entries created since that date and move to
Access. If you look in Outlook at "All Journal Fields" you see
"Created." I have tried to refer to it in VBA code as the following:

Item.CreateTime
Item.Created

Both returned a "Object doesn't support this object or method" error.
References to other Journal fields work OK.

I also have been trying to use this field in a folder Items Restrict
clause, but get a "Condition Not Valid" error.

Is is possible to refer to Journal Create Date in VBA Code? Thanks.
 
When in doubt, check the object browser: Press ALt+F11 to open the VBA environment in Outlook, then press F2. The property you're looking for is CreationTime.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Back
Top