I saw this artice, and am trying to figure out how to go in reverse.

I have a simple SQL server database table, and I want to update the outlook contact list with some contact info that is in the SQL table.

Is there an easy way to do this. I have seen genius connect, but what I am doing is only copying contacts over, not all of hte other outlook components, so 700.00 for 5 people to copy from sql server to outlook seems a little extreme..

thanks

tim

Your article is very good. However, when I run your code in my DTS package, Logon Box prompted. So I should enter password to run through. Then how can I make it a scheduled job and run it automatically? A job cannot take input as far as I know.

Thank you very much,

Augustine.

Yes, I use windows auth accessing sql server. That user, I, have access to outlook. SQLserver user is the same as that of window user because it uses the windows auth. Here actually, outlook, sqlserver and windows uses all the same windows authentication.

Thanks,