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
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString ="Exchange 4.0; MAPILEVEL=Personal Folders|Inbox\CompanyName\;PROFILE=OUTLOOK;DATABASE=C:\Users\UserName\AppData\Local\Temp\;"