View Full Version : Updating Outlook from SQL Server


Gerhard
03-10-2006, 04:09 AM
I have an SQL database that collects contact information from a web
application. How can I synchronize this with what is in Outlook? I want to
be able to add any new contacts, and update any changes in a contact's
information.

Thanks for your help.

Peter Huang [MSFT]
03-10-2006, 07:35 AM
Hi,

Currently I am researching the issue and we will reply here with more
information as soon as possible.
If you have any more concerns on it, please feel free to post here.

Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Peter Huang [MSFT]
03-10-2006, 07:35 AM
Hi,

Currently I am researching the issue and we will reply here with more
information as soon as possible.
If you have any more concerns on it, please feel free to post here.

Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Peter Huang [MSFT]
03-13-2006, 03:07 AM
Hi

Also there is an Exchange/Outlook IISAM Driver which works with ADO, but it
has many limitation.
So far where did you want to run the code that update the contacts.
If you want to run against the outlook client, we can use Outlook Object
Modal to update the Contacts.
Or we can use WebDAV (Code can run anywhere)
and
CDOEX and/or ADO with the EXOLEDB Provider (Code would need to run on the
Exchange Server).

Here are some information for your referecne.

OOM:
Outlook Object Model (OOM)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_14.asp?frame
=true

Outlook named properties are not supported by MAPI or CDO
http://support.microsoft.com/default.aspx?scid=kb;en-us;266353

ContactItem Object [Outlook 2003 VBA Language Reference]
http://msdn.microsoft.com/library/en-us/vbaol11/html/olobjContactItem_HV0524
7818.asp?frame=true

WebDAV:
Creating a Contact in the Exchange Store (WebDAV)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_creating_a_contact
_webdav.asp?frame=true

Deleting a contact involves removing the contact item from the Exchange
store.
http://msdn.microsoft.com/library/en-us/wss/wss/_exch2k_deleting_a_contact_w
ebdav.asp?frame=true

CDOEX/EXOLEDB:
Collaboration Data Objects for Exchange (CDOEX)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_3.asp?frame=
true

Person CoClass
http://msdn.microsoft.com/library/en-us/wss/wss/_cdo_person_coclass.asp?fram
e=true

Collaboration Data Objects for Exchange (CDOEX)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_3.asp?frame=
true

Saving Contacts to Active Directory
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_saving_contacts_to
_active_directory.asp?frame=true

Adding Contact Information into Messages with CDOEX
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_clb_adding_contact_inform
ation_into_messages_with_cdoex_vb.asp?frame=true


BTW: for exchange server side code, I think you may try to post in the
exchange dev newsgroup.
Exchange2000.development queue.

However, this queue is not a MSDN managed queue yet. That means you won't
be guranteed to get a reply in 2 business days there. So if the issue is
urgent for you, I think the best way is to use one of your MSDN subscriber
free support incident to contact our customer support service. There will
be one Exchange dev support engineer working specially with you on it.
Please visit the following page for how to submit it:
http://msdn.microsoft.com/subscriptions/support/default.aspx


If you have any more concerns, please feel free to post here. Thanks very
much for your understanding.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Peter Huang [MSFT]
03-13-2006, 03:07 AM
Hi

Also there is an Exchange/Outlook IISAM Driver which works with ADO, but it
has many limitation.
So far where did you want to run the code that update the contacts.
If you want to run against the outlook client, we can use Outlook Object
Modal to update the Contacts.
Or we can use WebDAV (Code can run anywhere)
and
CDOEX and/or ADO with the EXOLEDB Provider (Code would need to run on the
Exchange Server).

Here are some information for your referecne.

OOM:
Outlook Object Model (OOM)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_14.asp?frame
=true

Outlook named properties are not supported by MAPI or CDO
http://support.microsoft.com/default.aspx?scid=kb;en-us;266353

ContactItem Object [Outlook 2003 VBA Language Reference]
http://msdn.microsoft.com/library/en-us/vbaol11/html/olobjContactItem_HV0524
7818.asp?frame=true

WebDAV:
Creating a Contact in the Exchange Store (WebDAV)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_creating_a_contact
_webdav.asp?frame=true

Deleting a contact involves removing the contact item from the Exchange
store.
http://msdn.microsoft.com/library/en-us/wss/wss/_exch2k_deleting_a_contact_w
ebdav.asp?frame=true

CDOEX/EXOLEDB:
Collaboration Data Objects for Exchange (CDOEX)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_3.asp?frame=
true

Person CoClass
http://msdn.microsoft.com/library/en-us/wss/wss/_cdo_person_coclass.asp?fram
e=true

Collaboration Data Objects for Exchange (CDOEX)
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_3.asp?frame=
true

Saving Contacts to Active Directory
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_saving_contacts_to
_active_directory.asp?frame=true

Adding Contact Information into Messages with CDOEX
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_clb_adding_contact_inform
ation_into_messages_with_cdoex_vb.asp?frame=true


BTW: for exchange server side code, I think you may try to post in the
exchange dev newsgroup.
Exchange2000.development queue.

However, this queue is not a MSDN managed queue yet. That means you won't
be guranteed to get a reply in 2 business days there. So if the issue is
urgent for you, I think the best way is to use one of your MSDN subscriber
free support incident to contact our customer support service. There will
be one Exchange dev support engineer working specially with you on it.
Please visit the following page for how to submit it:
http://msdn.microsoft.com/subscriptions/support/default.aspx


If you have any more concerns, please feel free to post here. Thanks very
much for your understanding.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Gerhard
03-15-2006, 11:49 PM
Thank you. Let me study this and see if I have any more questions. Bob

""Peter Huang" [MSFT]" wrote:

> Hi
>
> Also there is an Exchange/Outlook IISAM Driver which works with ADO, but it
> has many limitation.
> So far where did you want to run the code that update the contacts.
> If you want to run against the outlook client, we can use Outlook Object
> Modal to update the Contacts.
> Or we can use WebDAV (Code can run anywhere)
> and
> CDOEX and/or ADO with the EXOLEDB Provider (Code would need to run on the
> Exchange Server).
>
> Here are some information for your referecne.
>
> OOM:
> Outlook Object Model (OOM)
> http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_14.asp?frame
> =true
>
> Outlook named properties are not supported by MAPI or CDO
> http://support.microsoft.com/default.aspx?scid=kb;en-us;266353
>
> ContactItem Object [Outlook 2003 VBA Language Reference]
> http://msdn.microsoft.com/library/en-us/vbaol11/html/olobjContactItem_HV0524
> 7818.asp?frame=true
>
> WebDAV:
> Creating a Contact in the Exchange Store (WebDAV)
> http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_creating_a_contact
> _webdav.asp?frame=true
>
> Deleting a contact involves removing the contact item from the Exchange
> store.
> http://msdn.microsoft.com/library/en-us/wss/wss/_exch2k_deleting_a_contact_w
> ebdav.asp?frame=true
>
> CDOEX/EXOLEDB:
> Collaboration Data Objects for Exchange (CDOEX)
> http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_3.asp?frame=
> true
>
> Person CoClass
> http://msdn.microsoft.com/library/en-us/wss/wss/_cdo_person_coclass.asp?fram
> e=true
>
> Collaboration Data Objects for Exchange (CDOEX)
> http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_techsel_tech_3.asp?frame=
> true
>
> Saving Contacts to Active Directory
> http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_saving_contacts_to
> _active_directory.asp?frame=true
>
> Adding Contact Information into Messages with CDOEX
> http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_clb_adding_contact_inform
> ation_into_messages_with_cdoex_vb.asp?frame=true
>
>
> BTW: for exchange server side code, I think you may try to post in the
> exchange dev newsgroup.
> Exchange2000.development queue.
>
> However, this queue is not a MSDN managed queue yet. That means you won't
> be guranteed to get a reply in 2 business days there. So if the issue is
> urgent for you, I think the best way is to use one of your MSDN subscriber
> free support incident to contact our customer support service. There will
> be one Exchange dev support engineer working specially with you on it.
> Please visit the following page for how to submit it:
> http://msdn.microsoft.com/subscriptions/support/default.aspx
>
>
> If you have any more concerns, please feel free to post here. Thanks very
> much for your understanding.
>
> Best regards,
>
> Peter Huang
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>