[AccessD] Checking Outlook Contact Info from Access

John Bartow john at winhaven.net
Fri Aug 3 03:58:33 CDT 2007


Hi Erwin,
I iterated through my Outlook Items and Customary was null in all of them.

So, just so I understand correctly, let me ask you:
Did you create the original value in the Outlook Customary property?
Do you know if Outlook itself ever uses this Customary property?

Thanks,
John
BTW what I am attempting to accomplish is to pull a contact from Outlook,
load its information into an Access table and from that point on keep he
data synchronized in both applications.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT
Helps
Sent: Friday, August 03, 2007 3:17 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Checking Outlook Contact Info from Access

There is a customerid property that I use.

Here a small extract from the code I use

"ITH" is a prefix I use to specify from which database the contact in
Outlook comes CustomerID is the company id ContactID is the contact from
this company id

When creating:
objOItem.CustomerID = "ITH" & CustomerID & "/" & ContactID
              

When updating:
Set objContactItem = oFolderContact.Items.Find("[CustomerID] = " & "ITH"
& CustomerID & "/" &ContactID)
If TypeName(objContactItem) = "Nothing" Then
	'Create new contact because it does not exist
      Set objContactItem = oFolderContact.Items.Add(olContactItem)
	' do your add new contact thingy
  Else
	'Update using found contact.
	'put your update code here
End If
                
Greetz
Erwin





More information about the AccessD mailing list