Bill,
Thanks for the time you took to check this out and reply. I found that you are right, outlook names are very sensitive. Case sensitivity was the problem. What is weird, is on some of the companyname(s) if I alltrim() my value it finds in and on some it will only find it if I don't alltrim() it. I have a cludge right now where I find for alltrim(.value) and if that is Null I find for the value and it works! Now I just need to find out why this is occuring, but I'm on the right track.
Rob
>I am having problems finding contacts in my public outlook folder. Here is the code:
>
>*********
>oOutLookObject = CreateObject("Outlook.Application")
>olNameSpace = oOutLookObject.GetNameSpace("MAPI")
>
>oContacts = ;
> olNameSpace.Folders("Public Folders").;
> Folders("All Public Folders").;
> Folders("MIS Contacts").Items
>
>oContactItem = oContacts.Find("[CompanyName] = " + "'" + ThisForm.txtCompany.Value + "'")
>
>
>*********
>No matter what I have in txtCompany, oContactItem is NULL, even when the company DOES exist in the public MIS CONTACTS folder. I have also tried padr(ThisForm.txtCompany,255,' ') since Microsoft Developer Network says companyname is 255.
>
>Any advice would be appreciated. By the way, anyone know how sensitive the FIND is (ie case or length).
>
>Thanks in advance,
>
>Rob
>I tried you basic example on my machine and it found names fine. I did not pad the Company Name. The things that have bitten me in the past are things like mis-spelled folder names ( Outlook names are case sensitive ) and one thing that really bit me once that if a folder name has leading or trailing spaces ( which are very hard to see and track down ) you must include them. I would look for these kinds of things to start with.
>Bill
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement