Complete Folderpath of Outlook Email

Hi Team,

I tried to search the topic of capturing the complete folder path of the eamils coming up in Outlook, but was not able to find any.

Can someone help me with the same.  What I want to achive is to capture the complete folder path of emails in VBA and then use the same later to open the emails from those paths.

Thanks,
Sandesh.
Sandesh555Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris BottomleySoftware Quality Lead EngineerCommented:
Can you explain what you mean by mails coming up ... i.e. when you open an email when you run some code or some particular explanation?

Chris
0
Sandesh555Author Commented:
Hi,

I want to get the complete folder path of the emails in the Inbox.  I have unlimited storage in my Inbox folder so I never move my emails out of this folder.

Now using VBA I want to get the complete folder path and store in an Access database.  Later to be used to open the emails again using VBA.

I hope this answers your question.

Thanks,
Sandesh.
0
Chris BottomleySoftware Quality Lead EngineerCommented:
The folder path is:
pstname\Inbox

from
?application.Session.GetDefaultFolder(olFolderInbox).FolderPath

If you are thinking it a DOS folder then you are mistaken.  It is a 'component' within the PST which is MS proprietary.  If you are already aware of this then you may not know that if for a given item you record the entryid for the item in access then you can access the item directly anywhere in VBA\\

Within outlook
?application.ActiveExplorer.Selection(1).entryid
00000000A6B27C64927F1E45934E9F5F3C971BE5C45A2000

IN any VBA application and assuming olkApp points to outlook:
?olkapp.Session.GetItemFromID("00000000A6B27C64927F1E45934E9F5F3C971BE5C45A2000").subject
dbms

Chris
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Chris BottomleySoftware Quality Lead EngineerCommented:
IF I have the wrong idea still then sorry but can you suggest anything to help narrow in on your needs?

Chris
0
Sandesh555Author Commented:
Thanks a lot... It is now working... :)
0
Chris BottomleySoftware Quality Lead EngineerCommented:
As an aside, if you check the help it is common practice to explain anything other than 'excellent' as a grade

IN essence as here, unless further question specific clarification is requested and not given then it is not considered good form to mark down the solution since without further knowledge of a deficiency how can the expert help.  

The idea (I believe) is to grade the solution and noting that the grading does not affect your points availability but does help guide others with the same problem then consider if you were (someone else) looking for exactly this same problem would you naturally prefer a second rate 'good' solution over an excellent?

Note my intent here is not to change what has happened but to improve your future relationship with the experts and to try and maintain the overall quality of the solutions in the site since I use it a lot myself in areas where I am less competent.

Please know I am glad to have helped in this instance and I wish you a pleasant experience with the site

Chris
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.