Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

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.
0
Sandesh555
Asked:
Sandesh555
  • 4
  • 2
1 Solution
 
Chris BottomleyCommented:
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 BottomleyCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Chris BottomleyCommented:
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 BottomleyCommented:
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
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now