[Last Call] Learn how to a build a cloud-first strategyRegister Now


Add pst, keep open for 15 minutes, then close

Posted on 2007-07-26
Medium Priority
Last Modified: 2010-04-08
I'm trying to standardize a process in Outlook into a nicely packaged tool that can be shared with coworkers, like and add-in in Excel.  Here's what I need to be able to do with a click of a button:

- Open a shared PST archive ("J:\archive.pst")
- Keep archive open for 15 minutes
- Close archive

The only code I have to date is to open the archive:

    Dim olkNS As Outlook.NameSpace
    Set olkNS = Application.GetNamespace("MAPI")
    olkNS.AddStore "J:\archive.pst"
    Set olkNS = Nothing

Once the code is developed, how do i package it to distribute to coworkers?  Is there a solution as "neat" as an add-in (.xla file)?  Sorry for ignorance, this is my first attempt at programming in Outlook.
Question by:bacdsap
  • 2
  • 2
LVL 76

Expert Comment

by:David Lee
ID: 19585009
Hi, bacdsap.

I never tried anything like what you describe, but it should be possible.  You'll need to activate a timer when the button is clicked and close the PST when the timer goes off.  As to the timer code, have a look at this question: http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_21941071.html

To distribute this to coworkers you'll want to build an add-in.  I recommend a COM add-in.  See this page for documentation on and links to resources that'll help you with that: http://www.outlookcode.com/article.aspx?ID=36

Author Comment

ID: 19755085
Have been out of the office and not yet had time to work on this.  These both look like they could work, but i'll get back to the list as soon as possible...
LVL 76

Accepted Solution

David Lee earned 2000 total points
ID: 19758254
No problem.  Thanks for the update.

Author Comment

ID: 19890711
Unfortunately, I'm having user rights issues imposed by my employer which seem to be preventing me from even opening the VBA editior in Outlook anymore.  Additionally, I don't have VB or knowledge of any other programming languages that would enable me to produce an add-in to distribute.  In reviewing the solution however, it did seem likely that I could have used it to solve the problem, so i am awarding BlueDevilFan the points.  Thanks again!

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question