Adam Ehrenworth
asked on
Access to pull Outlook Inbox email content - want it to work for my other team email box as well
I am currently using the following code to pull data directly from Outlook into access:
Instead of getting the email from my personal Inbox, however, I want this code to reference a team email box that is shared by colleagues so we can all use this tool.
The name of the account is different than just my email address so I think the syntax is more difficult to figure out:
PGHCC Support [JRDUS]
I tried to do different variations like this and I keep getting errors:
I know it is probably the brackets that are causing the issue... how can I make sure access knows the brackets are part of the inbox name?
Thanks for your help.
Adam
SELECT *
FROM Inbox IN 'C:\Temp'[Exchange 4.0;MAPILEVEL=me@mycompany.com|];
Instead of getting the email from my personal Inbox, however, I want this code to reference a team email box that is shared by colleagues so we can all use this tool.
The name of the account is different than just my email address so I think the syntax is more difficult to figure out:
PGHCC Support [JRDUS]
I tried to do different variations like this and I keep getting errors:
SELECT *
FROM Inbox IN 'C:\Temp'[Exchange 4.0;MAPILEVEL='PGHCC Support [JRDUS]'|];
I know it is probably the brackets that are causing the issue... how can I make sure access knows the brackets are part of the inbox name?
Thanks for your help.
Adam
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have recommended this question be closed as follows:
Accept: Allen Falcon (https:#a42222694)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
seth2740
Experts-Exchange Cleanup Volunteer