access outlook

[Van Eenoo Stefaan]

Hey,
I succeeded on creating distribution lists from access to outlook.
Concept: I use the username, and the code resolves the name to an email
adres.

One problem, some of the users have multiple email adresses on the exchange
server.

My code doesn't handle this problem.

Is there a way of choosing a certain adress, when there are multiple
adresses ?

Thnx
Stefaan

 

[SA]

There may be a couple of ways to do that (and you don't describe the method
you are going about interfacing with Exchange or Outlook so this answer is
pretty global), is to create a filtered set of address by address book,
limiting the filter to the target name (using the "restrict" method of the
address entry collection in the Outlook object model), loop through those to
find the one you want, grab the Address and then use the address in the
..recipientAdd method.

If using CDO or another method, then again you restrict the address
collection on an address book and when you find the address entry you want,
grab its EntryID and create a new AddressEntry object, set its entry ID and
then specify that the recipient use that Address entry.

HTH