Reading Outlook Contacts

Have you ever realized all you can do if Outlook contacts information were located into a database? If you have, this tip is for you. The first step is to take all that information out from Outlook so we can transform it into series of insert/update statements.

Start Microsoft Visual C# Express (you can download it for free from Microsoft’s site pending link).
Once downloaded and installed, create a new project and add Outlook’s library to it:
Go to Project -> Add Reference -> COM and select Microsoft Outlook 11.0 Object Library

Add the following line to the beginning of the file:

1using Outlook;

Update:

Last time I did it I had to change last line to this:

1using Outlook = Microsoft.Office.Interop.Outlook;

And here’s the code:

1Outlook.Application app = new ApplicationClass();
2Outlook.NameSpace ns = app.GetNamespace("MAPI");
3ns.Logon("outlook-username", "outlook-password", false, true);

1MAPIFolder apf;
2MAPIFolder contacts;
3string storeId;

1apf = ns.GetDefaultFolder(
2    OlDefaultFolders.olPublicFoldersAllPublicFolders);
3contacts = apf.Folders["your-public-folder-name"];
4
5storeId = contacts.StoreID;

1foreach (Object o in contacts.Items){ 
2    // Casting is important to avoid any distribution list
3    if (o is ContactItem)
4    {
5        ContactItem c = (ContactItem)o;
6        Console.Writeline(c.LastName + "n");
7    }
8}
9ns.Logoff();

Ok, we now know how to access and loop contacts, the missing thing is how to save them in an external database.
By the way, the ns.Logon function receives four parameters:

1. string Profile: that’s your username,
2. string Password: that’s your username,
3. bool ShowDialog: that’s your username and
4. bool NewSession: that’s your username

If the contact list you’re trying to access is not in the root level, but is a subfolder inside a subfolder inside a subfolder… like in the following image:

then this is the way you should go:

1apf = ns.GetDefaultFolder(
2    OlDefaultFolders.olPublicFoldersAllPublicFolders);
3contacts =
4    apf.Folders["International"].Folders["MX"].Folders["Admin Contacts"];

Sending mail from C#

An easy way to send email using C#:

 1System.Net.Mail.MailMessage message =
 2    new System.Net.Mail.MailMessage();
 3message.To.Add("luckyperson@online.microsoft.com");
 4message.Subject = "This is the Subject line";
 5message.From =
 6    new System.Net.Mail.MailAddress("from@online.microsoft.com");
 7message.Body = "This is the message body";
 8System.Net.Mail.SmtpClient smtp =
 9    new System.Net.Mail.SmtpClient("yoursmtphost");
10smtp.Send(message);

source: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=717&SiteID=1

System.Transactions

If you want to use System.Transactions in your application,

1. Right click project name in Solution Explorer and click Add a Reference…
2. In the .NET tab find and select the System.Transactions option
3. Click Ok and enjoy.

If you don’t add the reference you will get the following error while compiling:

The type or namespace name ‘Transactions’ does not exist in the namespace ‘System’ (are you missing an assembly reference?)

Creating a message box

Well, it is very simple…

1MessageBox.Show("Your message")

There are many available options… be sure you take a look at them.

Getting the Windows user name, domain, etc…

There are two ways to accomplish this, first the short way:

1Environment.UserName // user
2Environment.UserDomainName // domain

And the long way:

1System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString();

The long way will give you access to many more options so be sure to explore it.

How to read a text file

Add the following code at the beginning of your file:

1Using System.IO;

And here’s the code…

 1String text;
 2try {
 3  StreamReader sr = new StreamReader("C:file.txt");
 4  text = sr.ReadLine();
 5  while (text != null) {
 6    Console.WriteLine(text);
 7    text = sr.ReadLine();
 8  }
 9  sr.Close();
10  Console.ReadLine();
11}
12catch(Exception ex) {
13  Console.WriteLine("Exception: " + ex.Message);
14}

How to write a text file

Add the following code at the beginning of your file:

1Using System.IO;

And here it goes…

1try {
2  StreamWriter sw = new StreamWriter("C:file.txt");
3  sw.WriteLine("Hello World!!!");
4  sw.WriteLine("This is a test");
5  sw.Close();
6}
7catch(Exception e) {
8  Console.WriteLine("Exception: " + e.Message);
9}

How to connect to Access

Code:

 1using System.Data.OleDb;
 2...
 3
 4OleDbConnection conn = new OleDbConnection(
 5    "Provider=Microsoft.Jet.OLEDB.4.0;" +
 6    "Data Source=C:database.mdb;" +
 7    "Jet OLEDB:Database Password=password");
 8conn.Open();
 9
10OleDbCommand cmd =  new OleDbCommand("select * from mytable", conn);
11OleDbDataReader dr = cmd.ExecuteReader();
12while (dr.Read())
13{
14    Console.WriteLine(dr.GetString(0));
15}
16conn.Close();

How to connect to MySQL

See my MySQL section.

Error: IErrorInfo.GetDescription Failed with E_FAIL(0x80004005)

When you are querying a database you get this error. The reason is your query is using a keyword for a column name, table, etc. It does not matter if your query works well when you execute it directly in your database manager, remember there are more layers between C# and your database.

Data Types for C# and MSAccess 2002

If you want to do a “perfect” match between data types in MSAccess and C#
C# data types

MS Access data types