Script or VBA to Export Public Folder 'Company Contacts'

[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

 

[Guest]

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.

 

[Guest]

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?

 

[Clint Marshall]

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?

 

[Guest]

Yes, I do. I need the answer to my other question though. What format does
the export need to be in?

 

[Clint Marshall]

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...