![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#3
|
|||
|
|||
![]()
I think I also have a valid string but when I use it (or your version below)
I get a run time error saying. Condition is not valid and a long number. Highlighting at my Set itm code. Here is all my code. Any ideas? I have this code in a module in Access 2000. Just to test it. Thanks Carol Private Sub test() Dim fld As Outlook.MAPIFolder Dim appOutlook As Outlook.Application Dim nms As Outlook.NameSpace Dim itms As Outlook.Items Dim itm As Outlook.ContactItem Set appOutlook = CreateObject("Outlook.Application") Set nms = appOutlook.GetNamespace("MAPI") Set fld = nms.GetDefaultFolder(olFolderContacts) 'Set what kind of folder Set itms = fld.Items 'Outlook folder item Dim strFullName As String strFullName = "Cherif Abdallah" strFind = "[FullName] = " & Chr(34) & strFullName & Chr(34) 'strFullName = """" & "[FullName] = " & strFullName & """" Debug.Print strFullName Set itm = fld.Items.Find(strFullName) 'Debug.Print itm.LastName ' End Sub "Sue Mosher [MVP-Outlook]" wrote in message ... strFind = "[FullName] = " & Chr(34) & strFullName & Chr(34) Set itm = fld.Items.Find(strFind) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Passing variable to the To field | Matthew Brewer | Outlook and VBA | 1 | June 9th 06 06:38 AM |
Variable Date Meetings | Susan Vega | Outlook - Calandaring | 1 | March 22nd 06 05:58 PM |
Outlook Application variable problem | Ram | Add-ins for Outlook | 0 | February 12th 06 03:25 PM |
Variable attachment and recipient vb | Xluser@work | Outlook and VBA | 1 | January 21st 06 10:05 AM |
string variable that contains formatting | Martin | Outlook and VBA | 4 | January 19th 06 10:49 AM |