Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   validate outlook contacts (custom forms) through excel (http://www.outlookbanter.com/outlook-using-contacts/14798-validate-outlook-contacts-custom-forms.html)

~Rama May 16th 06 12:12 AM

validate outlook contacts (custom forms) through excel
 
I'm trying to find an ODBC to connect to outlook's database, and I dont
know where to start from.

I eventually would like to create a billing custom form in contacts,
and be able to validate user information as well as add new users from
excel, and add them to outlook.

Can you please direct me or explain at least a starting point ?? find
an ODBC to outlook?

~Rama


Sue Mosher [MVP-Outlook] May 16th 06 12:26 AM

validate outlook contacts (custom forms) through excel
 
The customary way to handle validation for Outlook items would in the code behind the custom form.

Creating and updating items is done with the Outlook object model.

FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/comm...rogram_f orms

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"~Rama" wrote in message oups.com...
I'm trying to find an ODBC to connect to outlook's database, and I dont
know where to start from.

I eventually would like to create a billing custom form in contacts,
and be able to validate user information as well as add new users from
excel, and add them to outlook.

Can you please direct me or explain at least a starting point ?? find
an ODBC to outlook?

~Rama


~Rama May 16th 06 02:18 AM

validate outlook contacts (custom forms) through excel
 
Thanks a lot Sue! I checked that microsoft link, its very beneficial.In
addition, I've been into your outlookcode.com several times every day
to try to understand outlook ODBC first then move forward to the next
step with my project. But since i'm just a beginner, and having a hard
time getting a head start, or understand where does outlook's database
reside and how do I ODBC to it. are you aware of a link that guides me
a step by step method?

I greatly appreciate your support.


Sue Mosher [MVP-Outlook] May 16th 06 01:11 PM

validate outlook contacts (custom forms) through excel
 
There is no "Outlook ODBC" per se. While it is possible to access Outlook folders through OLE DB (see http://www.codeproject.com/database/...OLE%20DB%20Jet and http://msdn.microsoft.com/library/de...l/sa00h12.asp), that technique will not expose all the properties and objects that you are likely to want to work with to create new items using custom forms. You should use direct Outlook automation methods instead.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"~Rama" wrote in message oups.com...
Thanks a lot Sue! I checked that microsoft link, its very beneficial.In
addition, I've been into your outlookcode.com several times every day
to try to understand outlook ODBC first then move forward to the next
step with my project. But since i'm just a beginner, and having a hard
time getting a head start, or understand where does outlook's database
reside and how do I ODBC to it. are you aware of a link that guides me
a step by step method?

I greatly appreciate your support.



All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com