• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

Moving from Outlook to Exchange

I have a function (within VBA) that links to a folder in an Outlook inbox and reads the email subjects.  However, we are now migrating to MS Exchange running on our local server and I cannot connect.

My current, local string is below, but I could really do with some help converting it for Exchange.
Dim ADOConn As ADODB.Connection
Set ADOConn = New ADODB.Connection

With ADOConn
.Provider  = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString ="Exchange 4.0; MAPILEVEL=Personal Folders|Inbox\CompanyName\;PROFILE=OUTLOOK;DATABASE=C:\Users\UserName\AppData\Local\Temp\;"
End With

Open in new window

Andy Brown
Andy Brown
  • 2
  • 2
1 Solution
Hi Andrew,
Hope this helps.
see the final post at this link for code snippet for connecting to exchange server:
The article at this link, although dated, has still relevant background info that you should read.

This link shows steps with screenshots to maually connect to Exchange 2003 for calendar sharing, etc.

In case you are interested, this link reviews all the new features built into Exchange 2007:
Andy BrownDeveloperAuthor Commented:
Thanks - as always (hope you are keeping well).  I'll give it a try tomorrow at some point.
Andy BrownDeveloperAuthor Commented:
Great stuff - I got there in the end.
Glad I could help.  Thanks for the points and grade.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now