Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2011, 08:13 AM
nickl nickl is offline import public contacts to local contacts Windows 7 64bit import public contacts to local contacts Office 2010 64bit
Novice
import public contacts to local contacts
 
Join Date: Sep 2011
Posts: 2
nickl is on a distinguished road
Default import public contacts to local contacts

I'm not sure if this is possible but the bosses here have a contact list in the public folders that they essentially want copied to their local contacts whenever there is an addition or deletion. Basically they don't want to use both address books, they want all of these contacts auto-imported and synchronized. Does anyone know if this is possible, maybe with a script which is not at all my strong suit.
Reply With Quote
  #2  
Old 09-14-2011, 10:29 AM
saigasmith saigasmith is offline import public contacts to local contacts Windows 7 64bit import public contacts to local contacts Office 2010 64bit
Competent Performer
 
Join Date: Mar 2011
Posts: 150
saigasmith is on a distinguished road
Default

See here for an sample macro that will do just that: http://www.pcreview.co.uk/forums/cop...-t3949209.html
Reply With Quote
  #3  
Old 09-16-2011, 05:22 AM
nickl nickl is offline import public contacts to local contacts Windows 7 64bit import public contacts to local contacts Office 2010 64bit
Novice
import public contacts to local contacts
 
Join Date: Sep 2011
Posts: 2
nickl is on a distinguished road
Default

Thanks, I'm giving it a shot but like I said this isn't my strong suit. I have this and it's erroring out with run time error 91 "object cariable or with block variable not set." Any ideas?

Private Sub Application_Startup()
Dim myNameSpace As Outlook.NameSpace
Dim myContactsFolder As Outlook.Folder
Dim myPublicContactsFolder As Outlook.Folder

Set myContactsFolder = myNameSpace.GetDefaultFolder(olFolderConflicts)
Set myPublicContactsFolder = myNameSpace.GetDefaultFolder(olPublicFoldersAllPub licFolders)
Set Item = myPublicContactsFolder.Items("New Phone List").CopyTo(myContactsFolder)
End Sub
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
import public contacts to local contacts How to automatic save Sending or replying contacts e-mails into contacts? biologus Outlook 1 09-12-2011 01:14 PM
Category issues with public folder contacts Amanda Outlook 0 06-27-2010 10:01 PM
Outlook 2007 import contacts (.csv) pacecal Outlook 0 06-20-2009 09:35 AM
import emails, contacts from Apple Mail to Outlook 2003 hippo430 Outlook 0 02-15-2009 05:53 PM
Import Contacts from web page flamingvan Outlook 0 12-11-2006 09:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft