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:

using Outlook;

Update:

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

using Outlook = Microsoft.Office.Interop.Outlook;

And here’s the code:

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

MAPIFolder apf;
MAPIFolder contacts;
string storeId;

apf = ns.GetDefaultFolder(
    OlDefaultFolders.olPublicFoldersAllPublicFolders);
contacts = apf.Folders["your-public-folder-name"];

storeId = contacts.StoreID;

foreach (Object o in contacts.Items){ 
    // Casting is important to avoid any distribution list
    if (o is ContactItem)
    {
        ContactItem c = (ContactItem)o;
        Console.Writeline(c.LastName + "n");
    }
}
ns.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:

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

---

Sending mail from C#

An easy way to send email using C#:

System.Net.Mail.MailMessage message =
    new System.Net.Mail.MailMessage();
message.To.Add("luckyperson@online.microsoft.com");
message.Subject = "This is the Subject line";
message.From =
    new System.Net.Mail.MailAddress("from@online.microsoft.com");
message.Body = "This is the message body";
System.Net.Mail.SmtpClient smtp =
    new System.Net.Mail.SmtpClient("yoursmtphost");
smtp.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…

MessageBox.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:

Environment.UserName // user
Environment.UserDomainName // domain

And the long way:

System.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:

Using System.IO;

And here’s the code…

String text;
try {
  StreamReader sr = new StreamReader("C:\\file.txt");
  text = sr.ReadLine();
  while (text != null) {
    Console.WriteLine(text);
    text = sr.ReadLine();
  }
  sr.Close();
  Console.ReadLine();
}
catch(Exception ex) {
  Console.WriteLine("Exception: " + ex.Message);
}

---

How to write a text file

Add the following code at the beginning of your file:

Using System.IO;

And here it goes…

try {
  StreamWriter sw = new StreamWriter("C:\\file.txt");
  sw.WriteLine("Hello World!!!");
  sw.WriteLine("This is a test");
  sw.Close();
}
catch(Exception e) {
  Console.WriteLine("Exception: " + e.Message);
}

---

How to connect to Access

Code:

using System.Data.OleDb;
...

OleDbConnection conn = new OleDbConnection(
    "Provider=Microsoft.Jet.OLEDB.4.0;" +
    "Data Source=C:\database.mdb;" +
    "Jet OLEDB:Database Password=password");
conn.Open();

OleDbCommand cmd =  new OleDbCommand("select * from mytable", conn);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
    Console.WriteLine(dr.GetString(0));
}
conn.Close();

---

How to connect to MySQL

See my MySQL section.

---

Error: IErrorInfo.GetDescription Failed with E_FAIL(0×80004005)

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

C#	CLR	Signed	Memory	Range
sbyte	System.Sbyte	Yes	1 byte	–128 to 127
byte	System.Byte	No	1 byte	0 to 255
short	System.Int16	Yes	2 bytes	–32768 to 32767
int	System.Int32	Yes	4 bytes	–2147483648 to 2147483647
long	System.Int64	Yes	8 bytes	–9223372036854775808 to 9223372036854775807
ushort	System.Uint16	No	2 bytes	0 to 65535
uint	System.Uint32	No	4 bytes	0 to 4294967295
ulong	System.Uint64	No	8 bytes	0 to 18446744073709551615
float	System.Single	Yes	4 bytes	–1.5×10-45 to 3.4 x x1038
double	System.Double	Yes	8 bytes	–5.0×10-324 to 1.7×10308
decimal	System.Decimal	Yes	12 bytes	1.0×10-28 to 7.9×1028
char	System.Char		2 bytes	Unicode characters
boolean	System.Boolean		1 byte	True or false

MS Access data types

MSAccess	Range	Decimal precision	Memory
Byte	0 to 255 (no fractions)	None	1 byte
Decimal	–10^38–1 through 10^38–1 (.adp) –10^28–1 through 10^28–1 (.mdb)	28	12bytes
Integer	–32768 to 32767 (no fractions).	None	2 bytes
Long Integer	(Default) –2147483648 to 2147483647 (no fractions).	None	4 bytes
Single	–3.402823E38 to –1.401298E–45 for negative values and 1.401298E–45 to 3.402823E38 for positive values.	7	4 bytes
Double	–1.79769313486231E308 to –4.94065645841247E–324 for negative values and 4.94065645841247E–324 to 1.79769313486231E308 for positive values.	15	8 bytes
Replication ID	Globally unique identifier (GUID)	N/A	16 bytes