Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Testing Addresses (2000)

    Anyone have a way to test email address from exchange? If I have a list of email addresses in word or excel, how can I get outlook to validate the address?

  2. #2
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Testing Addresses (2000)

    They are housed in Exchange, but you've entered them in an Office document? There might be other ways, but I think you'll have to write some code to read the address, create a mail item, stuff the address into the "TO" object, then use the Resolve method to test the address. Depending on your needs on an error you could display the problem address using msgbox, or you could write to a file.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Testing Addresses (2000)

    The are house in a group in exchange. No one seems to know how to get the email address out of the group just the names. So, having the names, I can recreate the email address (first.last@company.com). The problem is that, around 20% of the email address are some variation of first.last (things like middle names, Jr etc...) so I need a way to test my calculated address against the exchange list.

    There are around 1500 users in the group. 20% is around 300. so brute force is an option, just not my first choice.

    The only problem with code is that I am not overly familiar with the outlook object model, since I have never had a need to delve into it. (Word, Excel, Access no problem)

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Testing Addresses (2000)

    http://www.slipstick.com/contacts/dl.htm has everything known about DLs.

    There is an old utility that works with Outlook to read DLs and put the names in a message body, but i can't recall the name of it or find it at Slipstick. If i remember, i'll repost.

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Testing Addresses (2000)

    http://www.uwsp.edu/it/exchange/client_ext...ort/export.html

    if i recall correctly, it doesn't work for DLs in contacts, only in the GAL or PAB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •