Outlook et Access 2000
taz
-
28 avril 2000 à 15:10
cs_saraly Messages postés 2 Date d'inscription samedi 5 octobre 2002 Statut Membre Dernière intervention 21 janvier 2004 - 20 janv. 2004 à 17:57
cs_saraly Messages postés 2 Date d'inscription samedi 5 octobre 2002 Statut Membre Dernière intervention 21 janvier 2004 - 20 janv. 2004 à 17:57
A voir également:
- Outlook et Access 2000
- Programmeur access ✓ - Forum Visual Basic 6
- Info outlook - Forum Visual Basic
- Vb access - Conseils pratiques -Visual Basic / VB.NET
- Access vba - Forum Visual Basic
- Access like ✓ - Forum SQL
2 réponses
Salut taz,
Voici la copie d'un article de la base de connaissance MS.
J'espere que cela resoudra tes problemes.
A+
Xavier
PSS ID Number: Q208232
Article last modified on 12-04-1999
WINDOWS:2000
WINDOWS
====================================================================
-------------------------------------------------------------------------------
The information in this article applies to:
- Microsoft Outlook 2000
- Microsoft Access 2000
-------------------------------------------------------------------------------
SUMMARY
=====
This article provides an overview and sample code for creating Microsoft Outlook
contacts from information stored in a Microsoft Access database. The sample code
in the More Information section of this article should be run from a Microsoft
Access global module and provides a starting point for the development of a
complete solution.
MORE INFORMATION
==============
The Import and Export feature in Outlook does not allow you to import or export
information in user-defined fields (or properties). To import information into
these fields, you may need to create a programming solution that uses Automation
to convert the information.
The following sample code specifically converts information from Access into
newly-created Outlook contacts, using Data Access Objects (DAO). With
modifications, you can use this code as a basis for creating other types of
Outlook items, such as appointments, notes, tasks, and such.
There is also an overview and separate code example available on the Microsoft
Web site at the following location. It is the first example in the whitepaper.
http://www.microsoft.com/officedev/articles/sampauto.htm
Programming Considerations
--------------------------
- The following sample code uses the Northwind database included with Access
2000. If you installed Microsoft Office to a location other than the default,
be sure to change the path to the database in the sample code.
- You need to set a reference to the Microsoft Outlook 9.0 Object Library. A
reference to the Microsoft DAO 3.6 Object Library should be set by default.
- The field types used in this example are text, in both Access and Outlook. To
convert other types of fields, you must modify the code appropriately.
- The contacts are automatically placed in the default Contact folder, which is
at the same level as the Inbox.
- The CreateItem method used in this example creates a new Outlook contact
using the default form for the default contact folder. If you created a
custom Outlook Contact form, you must set the MessageClass field for each
item to the name of your custom form.
Microsoft provides programming examples for illustration only, without warranty
either expressed or implied, including, but not limited to, the implied
warranties of merchantability and/or fitness for a particular purpose. This
article assumes that you are familiar with the programming language being
demonstrated and the tools used to create and debug procedures. Microsoft
Support professionals can help explain the functionality of a particular
procedure, but they will not modify these examples to provide added
functionality or construct procedures to meet your specific needs. If you have
limited programming experience, you may want to contact the Microsoft fee-based
consulting line at (800) 936-5200. For more information about the support
options available from Microsoft, please see the following page on the World
Wide Web:
http://www.microsoft.com/support/supportnet/overview/overview.asp
Sample Code
-----------
Sub ExportAccessContactsToOutlook()
' Set up DAO Objects.
Dim oDataBase As Database
Dim rst As Recordset
Set oDataBase = OpenDatabase _
("c:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb")
Set rst = oDataBase.OpenRecordset("Customers")
' Set up Outlook Objects.
Dim ol As New Outlook.Application
Dim olns As Outlook.Namespace
Dim cf As Outlook.MAPIFolder
Dim c As Outlook.ContactItem
Dim Prop As Outlook.UserProperty
Set olns = ol.GetNamespace("MAPI")
Set cf = olns.GetDefaultFolder(olFolderContacts)
With rst
.MoveFirst
' Loop through the Microsoft Access records.
Do While Not .EOF
' Create a new Contact item.
Set c = ol.CreateItem(olContactItem)
' Specify which Outlook form to use.
' Change "IPM.Contact" to "IPM.Contact.<formname>" if you've
' created a custom Contact form in Outlook.
c.MessageClass = "IPM.Contact"
' Create all built-in Outlook fields.
If ![CompanyName] <> "" Then c.CompanyName = ![CompanyName]
If ![ContactName] <> "" Then c.FullName = ![ContactName]
' Create the first user property (UserField1).
Set Prop = c.UserProperties.Add("UserField1", olText)
' Set its value.
If ![CustomerID] <> "" Then Prop = ![CustomerID]
' Create the second user property (UserField2).
Set Prop = c.UserProperties.Add("UserField2", olText)
' Set its value and so on....
If ![Region] <> "" Then Prop = ![Region]
' Save the contact.
c.Save
.MoveNext
Loop
End With
End Sub
REFERENCES
========
For additional information about available resources and answers to
commonly-asked questions about Microsoft Outlook 2000 solutions, please see the
following article in the Microsoft Knowledge Base:
Q146636 OL2000: Questions About Custom Forms and Outlook Solutions
Additional query words: OutSol OutSol2000 OL2K
====================================================================
Keywords : kbcode kbprg kbdta OffVBS
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto
===========================================================================
Copyright Microsoft Corporation 1999.
Voici la copie d'un article de la base de connaissance MS.
J'espere que cela resoudra tes problemes.
A+
Xavier
PSS ID Number: Q208232
Article last modified on 12-04-1999
WINDOWS:2000
WINDOWS
====================================================================
-------------------------------------------------------------------------------
The information in this article applies to:
- Microsoft Outlook 2000
- Microsoft Access 2000
-------------------------------------------------------------------------------
SUMMARY
=====
This article provides an overview and sample code for creating Microsoft Outlook
contacts from information stored in a Microsoft Access database. The sample code
in the More Information section of this article should be run from a Microsoft
Access global module and provides a starting point for the development of a
complete solution.
MORE INFORMATION
==============
The Import and Export feature in Outlook does not allow you to import or export
information in user-defined fields (or properties). To import information into
these fields, you may need to create a programming solution that uses Automation
to convert the information.
The following sample code specifically converts information from Access into
newly-created Outlook contacts, using Data Access Objects (DAO). With
modifications, you can use this code as a basis for creating other types of
Outlook items, such as appointments, notes, tasks, and such.
There is also an overview and separate code example available on the Microsoft
Web site at the following location. It is the first example in the whitepaper.
http://www.microsoft.com/officedev/articles/sampauto.htm
Programming Considerations
--------------------------
- The following sample code uses the Northwind database included with Access
2000. If you installed Microsoft Office to a location other than the default,
be sure to change the path to the database in the sample code.
- You need to set a reference to the Microsoft Outlook 9.0 Object Library. A
reference to the Microsoft DAO 3.6 Object Library should be set by default.
- The field types used in this example are text, in both Access and Outlook. To
convert other types of fields, you must modify the code appropriately.
- The contacts are automatically placed in the default Contact folder, which is
at the same level as the Inbox.
- The CreateItem method used in this example creates a new Outlook contact
using the default form for the default contact folder. If you created a
custom Outlook Contact form, you must set the MessageClass field for each
item to the name of your custom form.
Microsoft provides programming examples for illustration only, without warranty
either expressed or implied, including, but not limited to, the implied
warranties of merchantability and/or fitness for a particular purpose. This
article assumes that you are familiar with the programming language being
demonstrated and the tools used to create and debug procedures. Microsoft
Support professionals can help explain the functionality of a particular
procedure, but they will not modify these examples to provide added
functionality or construct procedures to meet your specific needs. If you have
limited programming experience, you may want to contact the Microsoft fee-based
consulting line at (800) 936-5200. For more information about the support
options available from Microsoft, please see the following page on the World
Wide Web:
http://www.microsoft.com/support/supportnet/overview/overview.asp
Sample Code
-----------
Sub ExportAccessContactsToOutlook()
' Set up DAO Objects.
Dim oDataBase As Database
Dim rst As Recordset
Set oDataBase = OpenDatabase _
("c:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb")
Set rst = oDataBase.OpenRecordset("Customers")
' Set up Outlook Objects.
Dim ol As New Outlook.Application
Dim olns As Outlook.Namespace
Dim cf As Outlook.MAPIFolder
Dim c As Outlook.ContactItem
Dim Prop As Outlook.UserProperty
Set olns = ol.GetNamespace("MAPI")
Set cf = olns.GetDefaultFolder(olFolderContacts)
With rst
.MoveFirst
' Loop through the Microsoft Access records.
Do While Not .EOF
' Create a new Contact item.
Set c = ol.CreateItem(olContactItem)
' Specify which Outlook form to use.
' Change "IPM.Contact" to "IPM.Contact.<formname>" if you've
' created a custom Contact form in Outlook.
c.MessageClass = "IPM.Contact"
' Create all built-in Outlook fields.
If ![CompanyName] <> "" Then c.CompanyName = ![CompanyName]
If ![ContactName] <> "" Then c.FullName = ![ContactName]
' Create the first user property (UserField1).
Set Prop = c.UserProperties.Add("UserField1", olText)
' Set its value.
If ![CustomerID] <> "" Then Prop = ![CustomerID]
' Create the second user property (UserField2).
Set Prop = c.UserProperties.Add("UserField2", olText)
' Set its value and so on....
If ![Region] <> "" Then Prop = ![Region]
' Save the contact.
c.Save
.MoveNext
Loop
End With
End Sub
REFERENCES
========
For additional information about available resources and answers to
commonly-asked questions about Microsoft Outlook 2000 solutions, please see the
following article in the Microsoft Knowledge Base:
Q146636 OL2000: Questions About Custom Forms and Outlook Solutions
Additional query words: OutSol OutSol2000 OL2K
====================================================================
Keywords : kbcode kbprg kbdta OffVBS
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto
===========================================================================
Copyright Microsoft Corporation 1999.
cs_saraly
Messages postés
2
Date d'inscription
samedi 5 octobre 2002
Statut
Membre
Dernière intervention
21 janvier 2004
20 janv. 2004 à 17:57
20 janv. 2004 à 17:57
Bjr TT le monde
Voila, je suis en train de faire une appli sous access(VBA) qui importe et exporte des données depuis un fichier txt vers l'agenda d'Outlook et vice versa.
Mon probleme c'est que on me demande de personnalisé le formulaire calendrier.
J'arrive depuis outlook a modifié le formulaire en y rajoutant de nouveaux onglets contenant mes nouveaux champs
MAIS !!!! .... je ne sais pas comment faire une correspondance entre mes champs sources(données sources ) et les nouveaux champs outlook(champs du formulaire modifié (2 eme onglet du formulaire))
D'ailleurs, je ne suis mme pas sûr que c'est comme ça que je dois proceder
Merci de m'aider
Voila, je suis en train de faire une appli sous access(VBA) qui importe et exporte des données depuis un fichier txt vers l'agenda d'Outlook et vice versa.
Mon probleme c'est que on me demande de personnalisé le formulaire calendrier.
J'arrive depuis outlook a modifié le formulaire en y rajoutant de nouveaux onglets contenant mes nouveaux champs
MAIS !!!! .... je ne sais pas comment faire une correspondance entre mes champs sources(données sources ) et les nouveaux champs outlook(champs du formulaire modifié (2 eme onglet du formulaire))
D'ailleurs, je ne suis mme pas sûr que c'est comme ça que je dois proceder
Merci de m'aider
