Pick Folder Substitute-----IMP AND URGENT


Outlook version
Outlook 2010 32 bit
Email Account

i have outlook installed on my machine that has 4 mailbox in it( one is my default inbox, other three are my work related exchange server mailboxes)

i have created a tool, that creates an excel file of emails marked with a specific category for a specified date range


to choose mailbox from which email is required

Temp solution:- i have used pick folder , which works absolutely fine


[Set objNameSpace = objAppl.GetNamespace("MAPI")

Set ContactsFolder = objNameSpace.PickFolder]

Work Around:- i want to hard code it to second account's inbox folder, which i am unable to do


can anyone help me with this



Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange


Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server 2013
Are they actual accounts or secondary mailboxes (managed mailboxes)?

If an actual account, check out the second macro: Macro using a specific account. The code will check all of the accounts in the list and choose the one that matches the address string.

The macro at Send email from another address using VBA may work for a managed mailbox.
Hi Diane,

Good day!

Can you suggest an alternate to the pickfolder function? I have two email accounts at work but the pickfolder function opens my default mailbox. while I need it to open the other mailbox, which my colleague and I share when working. Any suggestions will be appreciated.

Thank you.