geoffnoakes
New Member
- Outlook version
- Outlook 2019 32-bit
- Email Account
- Exchange Server
I am using Outlook 2016 32-bit on a PC running Windows 10. I want to be able to search programmatically (i.e., VBA or VBS) for Contacts based on their CreationTime. I know that one particular Contact has a CreationTime of 20191101132354 (which is the YYYYMMDDHHMMSS value of when the Contact was created). How do I create a Restrict method to lookup Contacts based on their CreationTime?
When I try any of these attempts, they each fail:
"[CreationTime] = 20191101132354"
"[CreationTime] = '20191101132354'"
"[CreationTime] > 20190101000000 And "[CreationTime] <= 20191231235959"
"[CreationTime] > '20190101000000' And "[CreationTime] <= '20191231235959'"
Thanks...
Geoff
When I try any of these attempts, they each fail:
"[CreationTime] = 20191101132354"
"[CreationTime] = '20191101132354'"
"[CreationTime] > 20190101000000 And "[CreationTime] <= 20191231235959"
"[CreationTime] > '20190101000000' And "[CreationTime] <= '20191231235959'"
Thanks...
Geoff