Using Journal Create Date in Code

[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.

 

[Sue Mosher [MVP]]

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