CodeWidgets.com Online Source Code Library -ASP, ASP.NET, VB, VB.Net, Microsoft® Access, Javascript, VBScript, Website Design, Web Applications, Custom Programming Services Available.

 CodeWidgets.com ASP, ASP.NET, VB, VB.Net,
Microsoft® Access, Javascript, VBScript,
Website Design, Web Applications
Shopping Cart (0) Items $0.00      
 CodeWidgets.com
CodeWidgets.com

 

Website Stats to Date

Pages Viewed 4,401,732
Visitors 1,206,536
Widgets Viewed 3,009,755
Since January 1/2003
 
 
Active Users: 15
 

 
PayPal: Secure online payments!
 
Widget #CS0130

Create Outlook Contact entries from Microsoft® Access.

Create Outlook Contact entries from Microsoft® Access.

Send Link

Questions

Currency Conv.
  Widget Info  
Microsoft® Access 2000/XP

Public Sub ToOutlookContact(ByVal m_Firstname As String, ByVal m_LastName As String, ByVal m_Address As String, ByVal m_City As String, ByVal m_Region As String, ByVal m_Code As String, ByVal m_Phone As String)
On Error GoTo errTrap
Dim oApp As New Outlook.Application
Dim oNameSpace As Outlook.NameSpace
Dim oContactItem As Outlook.ContactItem
Set oContactItem = oApp.CreateItem(olContactItem)
With oContactItem
.Firstname = m_Firstname
.LastName = m_LastName
.BusinessAddress = m_Address
.BusinessAddressCity = m_City
.BusinessAddressState = m_Region
.BusinessAddressPostalCode = m_Code
.BusinessTelephoneNumber = m_Phone
.Save
End With
Err_Exit:
Set oContactItem = Nothing
Set oApp = Nothing
Exit Sub
errTrap:
'Code to handle errors goes here
Resume Err_Exit
End Sub

 Licensing
Format: HTML Article
Online Document
Licencing Terms: No Restrictions
Re-Distribution Permitted
This source code is provided to you "as is" without warranty
CLICK HERE FOR TERMS OF USE
Copyright 2002-2006 Comrie Software Solutions
 Related Widgets

Alternate row colors on reports with Microsoft® Access
Calendar Reports (Monthly View) For Microsoft® Access
Calendar Reports (Weekly View) For Microsoft® Access
Change Conditional Formating in code (Microsoft® Access)
Create Outlook Calendar entries from Microsoft® Access.

ShoppingCart Empty
Services Contact Info Legal Info
Designated trademarks and brand names are the property of their respective owners.

By accessing this website it is assumed that you agree to the TERMS OF USE.

Send questions or comments regarding this website to  Comrie Software Solutions.

Click here for a complete list of available Widgets.