Hi everyone, Please excuse the cross posting but I have been searching long and hard for an answer to this and haven't been able to find one. I can't be the only person who needs to do this. I have Exchange 2000 and SQL 2000 running on the same box. I have a number of tables in SQL that contain email addresses. I need to somehow make these email addresses available to Exchange (or Outlook). Is there any way to do this? Can a newer version of Exchange or SQL do it? Please let me know what your thoughts are. Thanks, Ken VdB
What do you mean to make them available for exchange? Do you want them to appear in the address book? -- Wei Xiao [MSFT] SQL Server Storage Engine Development http://weblogs.asp.net/weix This posting is provided "AS IS" with no warranties, and confers no rights. "Ken VdB" wrote in message news:eyklbkqGFHA.3376@TK2MSFTNGP14.phx.gbl... > Hi everyone, > > > > Please excuse the cross posting but I have been searching long and hard > for an answer to this and haven't been able to find one. I can't be the > only person who needs to do this. > > > > I have Exchange 2000 and SQL 2000 running on the same box. I have a > number of tables in SQL that contain email addresses. I need to somehow > make these email addresses available to Exchange (or Outlook). > > > > Is there any way to do this? Can a newer version of Exchange or SQL do > it? Please let me know what your thoughts are. > > > > Thanks, > > > > Ken VdB > >
Yes, that is exactly what I would like. I see there being two approaches to this. 1. Exchange connects to SQL and shows the table/view as part of the Global Address Book 2. Outlook has another address book provider setup that connects directly to SQL. Option two is less convenient as it requires setup/configuration on each client machine. Ken. "wei xiao" wrote in message news:O2WYs0XHFHA.3628@TK2MSFTNGP15.phx.gbl... > What do you mean to make them available for exchange? Do you want them to > appear in the address book? > > > -- > Wei Xiao [MSFT] > SQL Server Storage Engine Development > http://weblogs.asp.net/weix > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > "Ken VdB" wrote in > message news:eyklbkqGFHA.3376@TK2MSFTNGP14.phx.gbl... >> Hi everyone, >> >> >> >> Please excuse the cross posting but I have been searching long and hard >> for an answer to this and haven't been able to find one. I can't be the >> only person who needs to do this. >> >> >> >> I have Exchange 2000 and SQL 2000 running on the same box. I have a >> number of tables in SQL that contain email addresses. I need to somehow >> make these email addresses available to Exchange (or Outlook). >> >> >> >> Is there any way to do this? Can a newer version of Exchange or SQL do >> it? Please let me know what your thoughts are. >> >> >> >> Thanks, >> >> >> >> Ken VdB >> >> > >
I have implemented similar systems that go through SQL and pull out the email addresses, then add them to a OU in active directory as contacts with the appropriate names and email addresses. I have also gone the other way where I dredge active directory and populate SQL tables. I use ADSI and VBScript. I have also used this to create address book synchronization between co-existing email systems (cc:Mail, Exchange 5.5 in a separate domain and groupwise). I set the scripts to run each night to synchronize the systems. Once you are familiar with ADSI, then it is relatively easy to accomplish this. -- JOHN ABBOTT "Ken VdB" wrote in message news:eyklbkqGFHA.3376@TK2MSFTNGP14.phx.gbl... > Hi everyone, > > > > Please excuse the cross posting but I have been searching long and hard > for an answer to this and haven't been able to find one. I can't be the > only person who needs to do this. > > > > I have Exchange 2000 and SQL 2000 running on the same box. I have a > number of tables in SQL that contain email addresses. I need to somehow > make these email addresses available to Exchange (or Outlook). > > > > Is there any way to do this? Can a newer version of Exchange or SQL do > it? Please let me know what your thoughts are. > > > > Thanks, > > > > Ken VdB > >
