VB and Outlook Contacts

Question

I am trying to import, or copy, the contacts from Outlook into a SQL database using Visual Basic 2005 Express.  I do know how to do it using Access VB, but I want it to look professional.  Thanks all.

Fred.

Answer 1

You forgot to ask a question.

Answer 2

Sorry, my question is how do I import the contact list into a SQL database using VB 2005 express.

Thanks

Answer 3

Hi Fred,

 

Based on your post, you need to get the contact items from the Outlook and import the contact items into a SQL database. You can take the two steps to achieve this.

 

1.  Get all contact items from the outlook. Here is the code snippet to get all contact items from the outlook.

Code Snippet

Dim outlookApp As Microsoft.Office.Interop.Outlook._Application = _

New Microsoft.Office.Interop.Outlook.Application()

Dim cntctFolder As Microsoft.Office.Interop.Outlook.MAPIFolder = _

DirectCast(outlookApp.Session.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderContacts), _

Microsoft.Office.Interop.Outlook.MAPIFolder)

MessageBox.Show(cntctFolder.Items.Count.ToString)

Dim c As Microsoft.Office.Interop.Outlook.ContactItem

Dim objItems As Microsoft.Office.Interop.Outlook.Items

objItems = cntctFolder.Items

Dim iNumTasks As Integer = objItems.Count

For i As Integer = 1 To iNumTasks

c = objItems(i)

MessageBox.Show(c.FullName.ToString())

Next

 

I would like to recommend these articles about the outlook automation to you.

• Outlook Integration in C#.
• Outlook with .NET 2.0 .
• Programming examples for referencing items and folders in Outlook 2000.

2.  You need to create the Sql server database. Then you can use the SqlCommand to insert the contact items into the database. Please see the following article:

• How to create a SQL Server database programmatically by using ADO.NET and Visual Basic .NET.

 

Best regards,

Riquel.