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:ġ.
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?
0 kommentar(er)
