VB Script Help

[Rakesh]

Hi All, I am writing a VB script which fetches mails from my Outlook to excel.But the problem which I am facing is I have multiple mailboxes eg. A,B,C. What I need is to fetch the mails from specific mailbox let say B.But when I am executing the script it is fetching mails from the mailbox A which is not required.I have not prioritize the mailboxes in my code.Can somebody please explain the way to fetch mails from a specific mailbox.

 

[Diane Poremsky]

You need to identify the folder path and use it - see the code at Use a folder in another pst or Mailbox for the basics of using non-default data files.

 

[djGrizzly]

each mailbox should have an associated email address ( eg mailbox 1 being only emails to emailaddress1@domainname.com )...

Under the condition you are using VB SCRIPT vs VBA you might also try something like this...

Dim objOutlook 
 
Dim objNamespace 
 
Dim objMailbox 
 
Set objOutlook = WScript.CreateObject("Outlook.Application") 
 
Set objNamespace = objOutlook.GetNamespace("MAPI") 
 
Set objMailbox = objNamespace.Folders("[EMAIL="emailaddress1@domainname.com"]emailaddress1@domainname.com[/EMAIL]") 'where the email address corresponds to the mailbox you want to retrieve the mail items for

You could then retrieve any email folders for that mailbox... for instance this would retrieve the inbox for the previously retrieved mailbox.

Dim objInbox 
 
Set objInbox = objMailbox.Folders("Inbox")