A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Script or VBA to Export Public Folder 'Company Contacts'



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 15th 07, 09:53 PM posted to microsoft.public.outlook.program_vba
Clint Marshall
external usenet poster
 
Posts: 4
Default Script or VBA to Export Public Folder 'Company Contacts'

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


  #2  
Old August 17th 07, 02:06 AM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Script or VBA to Export Public Folder 'Company Contacts'

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.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Clint Marshall" wrote:

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



  #3  
Old August 17th 07, 04:46 PM posted to microsoft.public.outlook.program_vba
D.Lee
external usenet poster
 
Posts: 10
Default Script or VBA to Export Public Folder 'Company Contacts'

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?
--
David Lee - MVP Outlook

  #4  
Old August 21st 07, 01:42 PM posted to microsoft.public.outlook.program_vba
Clint Marshall
external usenet poster
 
Posts: 4
Default Script or VBA to Export Public Folder 'Company Contacts'

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?


"D.Lee" wrote in message
...
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?
--
David Lee - MVP Outlook



  #5  
Old August 21st 07, 11:50 PM posted to microsoft.public.outlook.program_vba
D.Lee
external usenet poster
 
Posts: 10
Default Script or VBA to Export Public Folder 'Company Contacts'

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


"Clint Marshall" wrote:

Got an idea?


  #6  
Old August 22nd 07, 03:15 PM posted to microsoft.public.outlook.program_vba
Clint Marshall
external usenet poster
 
Posts: 4
Default Script or VBA to Export Public Folder 'Company Contacts'

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


"D.Lee" wrote in message
...
Yes, I do. I need the answer to my other question though. What format
does
the export need to be in?
--
David Lee - MVP Outlook


"Clint Marshall" wrote:

Got an idea?




 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
script to add public folder contact list to available address books [email protected] Outlook - Using Contacts 2 December 23rd 06 07:06 PM
How do I export a PUBLIc FOLDER in OUTLOOK? Terry B Outlook - Using Contacts 1 July 19th 06 11:55 PM
Export Public Folder Contacts to Excel Directly mfhau Outlook - Using Contacts 1 May 6th 06 01:06 AM
export a public contact folder to excel? mjb Outlook - Using Contacts 1 January 20th 06 05:44 AM
Shared Company Calendar not updating - Public Folder andy Outlook - Calandaring 3 January 11th 06 11:55 PM


All times are GMT +1. The time now is 05:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.