Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 outlook folders in synch with the sql server 2000 database..

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-09 : 22:47:56
kiran writes "hi ,

i have this question regarding sql server 2000 and outlook.. is there a way to create folders in outlook from sql server 2000 database.. let me explain the problem..


lets say i have a USER table in the DB that has the first name , last name and email address... there is another PROJECT table that has a list of projects.. and a third table basically a join of PROJECT and USER tables called PROJECTUSER.. anytime there is a new project created and users added to the project, is there a way in sql server 2000 to automatically create a new folder in the outlook ,the name of the folder being the name of the project and, the items in the folder would be all the users attached to the project with their email addresses....Also, the vice-versa, meaning , if they enter a new user in the list in outlook , that should fire a macro which would just enter that user in the sql server DB.,.THANKS in advance"
   

- Advertisement -