![excel files open blank from outlook excel files open blank from outlook](https://img.bhs4.com/a8/8/a88f1ad54052ba7956a98a3fd67e2180cbd7437c_large.jpg)
![excel files open blank from outlook excel files open blank from outlook](https://csharpcorner-mindcrackerinc.netdna-ssl.com/article/how-to-connect-the-outlook-mail-to-excel-with-microsoft-flow/Images/2.jpg)
And then, click OK to close the dialog box, and press F5 key to run this code, and the specified Outlook folder will be opened immediately. Then, click Tools > References in the Microsoft Visual Basic for Applications window, in the popped out References-Project1 dialog box, check Microsoft Outlook Object Library option from the Available References list box, see screenshot:Ĥ. Note: In the above code, you can change the Inbox in the Set xFolder = xNameSpace.GetDefaultFolder(olFolderInbox)script to any other folder name that you want to open.ģ. Set xFolder = xNameSpace.GetDefaultFolder(olFolderInbox) Set xOutlookApp = New Outlook.Application VBA code: Open a specific Outlook folder from Excel file: Sub OpenOutlookFolder() Click Insert > Module, and paste the following macro in the Module Window. In Excel, hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. The following VBA code can help you to open a specific Outlook folder from Excel worksheet, please do as this:ġ.
![excel files open blank from outlook excel files open blank from outlook](https://cdn.extendoffice.com/images/stories/doc-outlook/doc-export-calendar/doc-calendar-to-excel-copy-01.png)
Open specific Outlook folder from Excel file with VBA code
#Excel files open blank from outlook how to#
Have you ever tried to open a specific Outlook folder from Excel file, such as opening the Inbox folder, Contacts folder or any other folder? This article, I will talk about how to open a desired Outlook folder from Excel workbook? How to open specific Outlook folder from Excel?