Integrating Access Contacts with SharePoint and Outlook

re: Integrating Access Contacts with SharePoint and Outlook

michelebkraus — Wed, 29 Aug 2007 20:29:03 GMT

zac, I'm not a developer but I want to put my contacts that are in a Public folder currently into SharePoint. I've spent several days exporting and importing data between Access and SharePoint and I'm not getting the data in the format I want. I want all Outlook fields (title, categories, user1, etc) to be in SharePoint AND I want the list I've created to then be a "Conact" content type so I can 1) Add back to Outlook and 2) Add a new contact giving me all the fields to populate. Is no one moving ALL their contact information to sharepoint????

re: Integrating Access Contacts with SharePoint and Outlook

Bill Forney — Wed, 29 Aug 2007 23:45:46 GMT

I am getting:

Run-time error '13':

Type mismatch

from this code... Suggestions?

re: Integrating Access Contacts with SharePoint and Outlook

Tom Wickerath — Thu, 30 Aug 2007 08:47:35 GMT

Hi Bill,

Make the following change in the helper routine:

Change:

Dim p As Property

To:

Dim p As DAO.Property

Also, make sure that you have a reference set to the DAO Object Library (Tools > References listing). As an alternative, you can deselect the checked reference to the ADO object library ("Microsoft ActiveX Data Objects {version} Library"), however, I recommend that you use the explicit declaration instead. This code suffers from a reference priority problem. To read more about this, please see the following article:

ADO and DAO Library References in Access Databases

http://www.access.qbuilt.com/html/ado_and_dao.html

While you are at it, add Option Explicit as the second line of code at the top of the module, if this most important line of code is missing, ie:

Option Compare Database

Option Explicit

and then add the following declaration in the Public Sub MakeContacts() subroutine:

Dim strTable As String

Dim fm As FieldMap

Dim td As TableDef

Dim db As Database

Dim i As Integer '<---Add this

To read more about why Option Explicit is so important, please see the following article:

Always Use Option Explicit

http://www.access.qbuilt.com/html/gem_tips.html#VBEOptions

I don't have SharePoint set up to actually test this code, but I was able to duplicate the error you reported.

Tom

re: Integrating Access Contacts with SharePoint and Outlook

Zac Woodall — Thu, 30 Aug 2007 18:40:57 GMT

Bill, are you using Option Explicit? If so, you'll need to "Dim i as Integer" at the top of MakeContacts.

Michele, you might be able to do it this way:

1) import your Outlook contacts into Access using the Outlook/Exchange import wizard (External Data-->Import-->More-->Outlook Folder)

2) run the code from this post on it (fixing up field names correctly)

3) export the table from Access to Sharepoint

4) go to the sharepoint list and choose open with outlook

HTH!

re: Integrating Access Contacts with SharePoint and Outlook

Seth Bacon — Thu, 30 Aug 2007 19:20:37 GMT

Thanks for the post! Great example code.

- Seth

re: Integrating Access Contacts with SharePoint and Outlook

Tom Wickerath — Fri, 31 Aug 2007 08:43:41 GMT

Hi Bill,

I posted the following reply last night, but for some reason unknown to me, it did not show up. This is a second attempt.

==============================

Hi Bill,

Make the following change in the helper routine:

Change:

Dim p As Property

To:

Dim p As DAO.Property

ADO and DAO Library References in Access Databases

http://www.access.qbuilt.com/html/ado_and_dao.html

While you are at it, add Option Explicit as the second line of code at the top of the module, if this most important line of code is missing, ie:

Option Compare Database

Option Explicit

and then add the following declaration in the Public Sub MakeContacts() subroutine:

Dim strTable As String

Dim fm As FieldMap

Dim td As TableDef

Dim db As Database

Dim i As Integer '<---Add this

To read more about why Option Explicit is so important, please see the following article:

Always Use Option Explicit

http://www.access.qbuilt.com/html/gem_tips.html#VBEOptions

I don't have SharePoint set up to actually test this code, but I was able to duplicate the error you reported.

Tom

re: Integrating Access Contacts with SharePoint and Outlook

Lorenzo — Fri, 31 Aug 2007 15:11:26 GMT

Well, good morning to all from italy

My problem is this.

With Outlook 2007 and BCM i want to import information in BCM from a database standard downloaded from OfficeOnline as Attività.accdb

How i can make , if the SQL Express 2005 engine not recognize this format of database?

thanks to all for the repaly and sorry for my bad english

Nuevas vistas de informe en Access 2007

Access — Thu, 11 Oct 2007 01:09:07 GMT

Access 2007 añade dos nuevas vistas a los informes. Además de la “Vista diseño” y “Vista preli minar

Cambiar las propiedades WSSTemplateID y WSSFieldID de una tabla y sus campos para hacerla compatible con Contactos de Outlook y Sharepoint.

Access — Thu, 25 Oct 2007 21:54:45 GMT

Mirando en plantillas y ejemplos de Access 2007, nos encontramos en algunos formularios con opciones

Contactos de Outlook en Access 2007

Access — Sun, 06 Apr 2008 23:12:00 GMT

Para que la Evas no tenga razón cuando nos achaca que nos prodigamos poco, copio aquí el artículo que