<div>
Thanks - as always (hope you are keeping well). &nbsp;I'll give it a try tomorrow at some point.
</div>


Thanks - as always (hope you are keeping well).  I'll give it a try tomorrow at some point.

<div>
Great stuff - I got there in the end.
</div>


<div>
Glad I could help. &nbsp;Thanks for the points and grade.
</div>


Glad I could help.  Thanks for the points and grade.

<div>
<div class="content wysiwyg-content">
I have a function (within VBA) that links to a folder in an Outlook inbox and reads the email subjects. &nbsp;However, we are now migrating to MS Exchange running on our local server and I cannot connect.<br />
<br />
My current, local string is below, but I could really do with some help converting it for Exchange.<br />

<pre><code id="code-1052495">Dim ADOConn As ADODB.Connection
Set ADOConn = New ADODB.Connection

With ADOConn
.Provider  = &quot;Microsoft.Jet.OLEDB.4.0&quot;
.ConnectionString =&quot;Exchange 4.0; MAPILEVEL=Personal Folders|Inbox\CompanyName\;PROFILE=OUTLOOK;DATABASE=C:\Users\UserName\AppData\Local\Temp\;&quot;
End With
</code></pre>
</div>
</div>


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.

Moving from Outlook to Exchange

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.