Solved

Searching Outlook Contacts from VBA fails

Posted on 2009-04-05
2
244 Views
Last Modified: 2012-05-06
Attached is some code I am running to check for duplicate contacts in Outlook 2003 before inserting a new one from Access 2003. The adding part works fine so I have not included it here.
The problem is that the find method (Line 20) fails with the error:

The property "FirstName" in the condition is not valid.

Any example code I can find (even with this same property used in the search) seems to do the finding in exactly the same way as this, but mine won't work!
Any thoughts on what is wrong here?
Dim rst As New ADODB.Recordset
    Dim cnn As New ADODB.Connection
    Dim appOutlook As New Outlook.Application
    Dim ns As Outlook.Namespace
    Dim fldContacts As Outlook.MAPIFolder
    Dim itms As Outlook.Items, itm As Outlook.ContactItem
    Dim objContactFolder As Object
    Dim findstr As String
    
    Set cnn = CurrentProject.Connection
    Set appOutlook = CreateObject("Outlook.Application")
    Set ns = appOutlook.GetNamespace("MAPI")
    Set fldContacts = ns.GetDefaultFolder(olFolderContacts)
    Set itms = fldContacts.Items
 
    rst.Open "SELECT Employees.* FROM Employees WHERE Employees.EmployeeID=" & EmpID, cnn, adOpenKeyset, adLockOptimistic
    rst.MoveFirst
    
    'Prevent duplicate contacts in Outlook.
    findstr = "[FirstName] = """ & rst!FirstName & """ and [LastName] = """ & rst!LastName & """"
    Set itm = itms.Find(findstr)
    If Not TypeName(itm) = "Nothing" Then
      Rem dupicate
      If MsgBox("Do you want to update the information for " & rst!FirstName & " " & rst!LastName & "?", vbApplicationModal + vbYesNo + vbQuestion + vbDefaultButton1) = vbNo Then
          itm = Nothing
      End If
    End If

Open in new window

0
Comment
Question by:allaboutmike
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24074594
Nothing obviously wrong ... are you sure firstname and lastname are valid fields in your database record?

Chris
0
 

Accepted Solution

by:
allaboutmike earned 0 total points
ID: 24074644
Chris, thanks for the answer, but it seems that Outlook had some issue. I have gone back to get an exact dump of the error for you and now it works with no code changes!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question