Hi All
I am working on a form that has a list box that display's emails from an Outlook 2010 Inbox. The record source for the list box is set to a query. With this query, I am using the following connection string:
The query only returns emails with attachments and that have been received in the last 48 hours.
I have two questions:
1. The query is very slow :banghead:. Is there any way to speed this up? The inbox has, on average, 1500+ emails in it. Is this the reason it is so slow?
2. The connection string I am using does not include the "Categories" column from Outlook. Is there a way to capture this in the query?
I am using Access 2010 and Outlook 2010.
Thanks in advance.
I am working on a form that has a list box that display's emails from an Outlook 2010 Inbox. The record source for the list box is set to a query. With this query, I am using the following connection string:
Code:
Outlook 9.0;MAPILEVEL=email@123.com|;PROFILE=C2;TABLETYPE=0;TABLENAME=Inbox;COLSETVERSION=12.0;DATABASE=%UserProfile%
\LOCALS~1\Temp\;TABLE=InboxThe query only returns emails with attachments and that have been received in the last 48 hours.
I have two questions:
1. The query is very slow :banghead:. Is there any way to speed this up? The inbox has, on average, 1500+ emails in it. Is this the reason it is so slow?
2. The connection string I am using does not include the "Categories" column from Outlook. Is there a way to capture this in the query?
I am using Access 2010 and Outlook 2010.
Thanks in advance.
