Connect from MS Access 2003 to Exchange Server

need some help with VBA code to connect database to Exchange server ... I am running the DB from an admin account ... just need to know how to connect to the Outlook mail exchange then in code to a specific user profile (i have a lsit of profiles in a table) what i am trying to do is update about 300 contact folders. thanks in advance for your help.
NEWJACKAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NEWJACKConnect With a Mentor Author Commented:
Yes I have ... but i dont want to link to 300 tables ... and i dont think its possible .. the machine that has the database is set to one profile so when i link the table its only one folder I am updating. Thanks.

0
 
Jeffrey CoachmanMIS LiasonCommented:
NEWJACK,

Have you tried this from Access?:
File-->Get External Data-->Link Tables
From the "Files of Type" dropdown, select: "Exchange"

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK
0
 
Jeffrey CoachmanMIS LiasonCommented:
NEWJACK,

If you are going to accept your own post as the solution, can you explain how it solves the issue?

Thanks

JeffCoachman
0
All Courses

From novice to tech pro — start learning today.