Link to home
Start Free TrialLog in
Avatar of Adam Ehrenworth
Adam EhrenworthFlag for United States of America

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:

SELECT *
FROM Inbox IN 'C:\Temp'[Exchange 4.0;MAPILEVEL=me@mycompany.com|];

Open in new window


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]'|];

Open in new window


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
Avatar of Allen Falcon
Allen Falcon
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Seth Simmons
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

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