Script or VBA to Export Public Folder 'Company Contacts'

  • Thread starter Thread starter Clint Marshall
  • Start date Start date
C

Clint Marshall

As part of a disaster recovery plan we're implementing, I need to export our
MS Exchange Public Folder "Company Contacts", zip it, and email it to a
backup email address.

Can anyone guide me in programming this so that I don't have to do it
manually every day? I have modest VBA skills.

Thank you for your help!

-Clint Marshall
 
Unfortunately you cannot automate the Import/Export Wizard in Outlook. If
you want to export to a .pst you have to do it manually. However, there are
ways that you can create a .pst and copy a folder to it using code. Even
then you can't schedule a task to do this as running Outlook code in the
context of a service is unsupported.
 
What format does the export need to be in? Is running this via a single
mouse click satisfactory, or does it have to run unattended?
 
A single mouse click would be a huge improvement over where we are today.
Unattended is better, but a single mouse click would make it dummy-proof and
let others share the burden.
Got an idea?
 
Yes, I do. I need the answer to my other question though. What format does
the export need to be in?
 
Sorry!
I'm importing the exported file into Outlook as a contacts list, so my guess
is that a .pst file would be ideal, but perhaps another format will work
just as well, or even better.
That's the only real criteria...
 
Back
Top