Verify email against address book?

[Chrissy]

Hello Everyone,

I am writing a VBScript that queries an Oracle database for leases that are expiring and then emails the leasing agent based on the "name" field in the database. The name is supposed to be entered as "First Name" "Last Name". The default smtp format for all employee is first initial last name @company.com. The problem is that since the text field you enter the name in excepts anything, there is room for typos and errors... Therefore, the email address may not be valid.

Since all of the email addresses should be for employees, is there a way to confirm the existence of the email address against the address book?

Any help or comments is appreciated. Thanks!

Chrissy

[mendhak]

It'd be easier if you provided this as a dropdown list or as an autosuggest feature that showed them possible values as they entered characters.

But this depends - where is the address book stored?

[Chrissy]

That is not possible. The script runs atutomatically and there is no user input. It pulls info directly from the database.

[mendhak]

In this case, if there's a typo in the script, there isn't going to be much in the way of corrections since services won't give you a "Did you mean?" response.

As for checking the existence, again, where is the actual address book stored?

[Chrissy]

We have Microsoft Exchange & Outlook. I would assume that the company address book would be stored on there somewhere... The scripts are run on the server, I was hoping there was a way to compare the email address that the script comes up with to what is stored in the company address book in Outlook.

[mendhak]

This is a big topic - AFAIK, to talk to Exchange, you need to learn how to use ADSI. Do a search for ADSI and read up on it. There's also a simple example here that you can use:

http://www.codeproject.com/KB/asp/se...&select=835752