[ExcelVBA] Re: searchin outlook address book

 

Graham ---- you might be onto something here

the AddressEntries property is a collection
a collection has a key
the key is ????

I am guessing, the key is the property (e.g. "ID") that you sort the list on....

So perhaps you can use the known ID to do a direct (I suspect implicit binary search) .

I have not tested it ---- but it would be simple for Michael.

db

--- In ExcelVBA@yahoogroups.com, "Graham Pearson" <me@...> wrote:
>
> I agree with Michael - a binary search algorithm will be much more efficient. You should find the entry you're looking for in, at most, 16 tries.
> However, I'm dumbfounded that Outlook.AddressEntries doesn't already have a "built-in" function for performing a binary search.
>
>
> ----- Original Message -----
> From: David Braithwaite
> To: ExcelVBA@yahoogroups.com
> Sent: Tuesday, March 06, 2012 11:09 AM
> Subject: [ExcelVBA] Re: searchin outlook address book
>
>
>
> Hi Michael
>
> Right now you are, on average, looking through 50% (25000) names each time
> you do a lookup.
>
> For each probe into the address list, you are making a networked access into
> this list.
>
> I don't have the resources to test this (no access to a "global address
> list"), but
>
> You might try
>
> Dim objAddressListEntries As Outlook.AddressEntries
>
> Set objAddressListEntries = objAddressList.AddressEntries
>
> objAddressListEntries.Sort "ID"
>
> then use a binary search algorithm. This would cut your average searches
> per item from 25,000 to less than 20.
>
> Db
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___