Google Outlook Calendar Synchronizer

I mentioned synching my Outlook and Google Calendars. Instead of waiting for somebody to do it for me I’m going to start doing it myself. I’m not sure I’ll finish but hopefully I can save somebody time in the future and provide a Visual Studio/Outlook tutorial on the way. I plan on publishing all source code as I go to make it easier for download.

Main Goal: Synch Outlook and Google Calendars

  • Goal 1: Enumerate Outlook Appointments
  • Goal 2: Schedule Enumeration
  • Goal 3: Enumerate Google Appointments
  • Goal 4: Compare Appointment Lists in a unified format.
  • Goal 5: Add and delete (Synchronize) appointments based on user settings.

To be able to access the Microsoft Office (2003) System through Visual Studio 2005 I needed VSTO, this is Visual Studio Tools for the Microsoft Office System or Visual Studio Tools for Office.

There are different VSTO packages and versions. I will not go into them. I do not because the whole thing confuses me.

Step 1: Install VSTO. Fortunately I had this CD through an MS partner program. However it will cost a few hundred dollars if you do not. You must have Office 2003 installed along with Office 2003 Service Pack 1. After installing the service pack, VSTO installed with no hitch although it was a pretty sluggish install.

Step 2: Learning the interface. Seeing as how Outlook will need to be open in order to enumerate the appointments, I have chosen to make an Outlook add-in. Fortunately I was able to find a few VSTO-Outlook Samples on Microsoft.com.

After installing VSTO, it is very easy to create a blank Outlook AddIn. Create a new project, choose either VB or C# (I use C#) and expand the list. Select “Office” and the “Outlook Add-in” Visual Studio installed templates as seen here.
VSTO Outlook Add-in

After clicking ok to create the blank project, I took a look at the Solution Explorer. Right now there is only one file that I am interested in. The main guts of code go into “ThisApplication.cs”.

Opening ThisApplication.cs showes to methods already created. These are “ThisApplication_Startup” and “ThisApplication_Shutdown”. You’ve probably guessed that the first one is fired at startup and the second and shutdown.

For my first test I thought I would just show myself how many appointments I currently have in Outlook. Before I go into that the first thing that you should keep in mind is that Outlook is all about MAPI folders. MAPI (Messing API or Messaging Application Programming Interface) basically is the interface dealing with messages and message stores. It kind of should be called MS MAPI as I believe that Microsoft owns the interface/protocol. You can read more about MAPI here and here.

The reason that I point out MAPI folders is that it is a generic folder. Your inbox is a MAPI folder, so is your outbox, calendar, contacts etc… All MAPI folders are of the type “Outlook.MAPIFolder”. This struck me as odd and I struggled with accepting this. Initially I thought that each folder should be a different type. I thought the Inbox and Outbox should be of an email type because it contained emails while the calendar would be yet another type. However this is more similar to a directory structure than a class so it should make more sense as we go along.

So on to my first Outlook Add-in. All that I did was place the following 3 lines in the Startup method and ran the program. VS is smart enough to add and run the add-in. All that you need to be sure of is that Outlook isn’t currently open.

Outlook.MAPIFolder Calendar = this.Session.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderCalendar);
Outlook.Items Appointments = Calendar.Items;
MessageBox.Show(Appointments.Count.ToString());

Upon running Outlook you should see a popup message with a number in it telling you how many appointments are in your Calendar. It is kind of useless except to show you that it works. However we are close to actually detailing the appointments at this point.

The next step is to iterate through the items and put them into a class that will make it easier for us later on. I ended up saving these items into a class. This way when we load the information from our Google calendar we can do so to this class with no problems.

You can see the source code here that I have for ENUMERATE OUTLOOK APPOINTMENTS USING VSTO.

I will be working on Goal 2 when I need a break durning my normal work day.

143 thoughts on “Google Outlook Calendar Synchronizer”

  1. I6500U China Unicom Custom version also supports 3G features Unicom business.
    Share – Shot is a camera shooting mode that uses Wi-Fi Direct in the
    background to automatically send photos to your friends as you shoot them, instead of e-mailing them after the fact.
    This is fully equipped with operating system Android OS, v4.

  2. You could definitely see your skills within the article you write.
    The arena hopes for even more passionate writers like you who aren’t afraid to mention how they believe.
    All the time go after your heart.

  3. While green electric solutions electrician you can go to the yellow pages.
    Some companies naturally charge more for a more competitive, better-delivered service, which makes it more
    convenient. Well, many electrical problems, from minor issues to tragically major ones.
    Many times when you are producing choices regarding renovating your residence.
    If a company employs you, you may be able to get exact salary data for this year in March.
    Reason #2 The safety of your home. Initially, of all; do not hire unqualified but cheap electricians.

  4. For the Xbox 360, you might have the Xbox Stay Marketplace.

    If you can’t hear the dialogue because of the music or gunfire, you must do something about it.

    The game also features numerous maps that compel players to plan their attack and upgrade beforehand.

  5. Whats up very nice website!! Man .. Beautiful .. Wonderful ..

    I’ll bookmark your web site and take the feeds
    additionally? I’m glad to find numerous helpful information here in the put up, we need develop extra techniques in this regard, thanks
    for sharing. . . . . .

  6. And phone card since you have to think so many different
    types of extra fees. These cards not only on this international prepaid phone calling cards
    for people who are sometimes out of the calling card.

  7. This is quite a relief to the masses as it is not quite easy to maintain the smart phone as it is a
    known fact that these devices are fragile in nature. – Beautiful Display ‘ The All New HTC One details haven’t been made official yet,
    but a 5′ full HD display is expected, and it’s something we’ll be more than happy with.
    As you all know by now, the Samsung Galaxy S ships with Android 2.

  8. GPS-Short for International Positioning Systems, has turn out to be an more
    and more supply of journey info assist in latest years. What’s more, it also supports coherent file technique
    like Windows NT. This may enable surveillance at evening over
    a wide radius.

  9. Please let me know if you’re looking for a article writer for your blog.

    You have some really good posts and I think I would be a good asset.
    If you ever want to take some of the load off, I’d love to write some material for your blog in exchange for a link back to mine.

    Please shoot me an email if interested. Many thanks!

  10. Carriers want you to stay with them so you will just
    upgrade the mobile phone with ‘discount’ but you need to stay with them for at least
    two years. But most journal articles have 8-point sort in figure captions that are as well
    modest to read on a 1280×800 screen. With the Split view feature in Samsung Galaxy S2 you can tilt your screen
    into landscape mode and last but not the least
    Touch Wiz 4 interface which brings quick access to Wi-Fi, GPS, and Bluetooth by pulling down notification bar.

  11. The turnkey franchise provider offers the rest, including.
    Sky-scrappers can also be much like banner ad campaigns, though the
    difference is they run vertically for the web page. For example in case
    you operate a weightloss nutrition practice think of partnering
    up which has a exercise website.

  12. However, with the rapid pace in the progress of technology,
    Smartphones has subsided the demand of both, Desktop PCs and Laptops.

    If you followed the proceedure carefully you must have something like this by now.
    A saucy text or phone pic sent to your loved one is a great way to keep the flames
    of passion burning, although I’m aware of certain infamous incidents of adulterers using them for evil.

  13. whoah this weblog is wonderful i really like studying your articles.
    Stay up the great work! You already know, lots of persons are hunting round for this
    info, you can aid them greatly.

  14. Next, the FHDA animations Alarm Pedometer Using Supervisor Software Having Rechargerabe that is Flash may be the proper
    decision. The FHDA 3D Sensor Pedometer Using USB Rechargerabe Using Boss Software is the
    better-selling item in Pedometer Classification. As FHDA 3D Sensor Pedometer Having USB Rechargerabe Using Manager Application is one of many best-selling Pedometer available in the
    marketplace today, you’ll find it easily in online and off-line keep.
    You may also find this system in Costco, Walmart, Best Get, Ebay and Amazon.

  15. 100s of high quality SAP computer software computer centered training (Entertaining CBTs) that make recommendations
    each step from your way. His cooking area helper, a Dutchman,
    palms us a mimosa, although faint Arabic music tinkles in the history.
    Manufacturing works are performed on all kinds of Stainless Steel Linens, G.

  16. Generally, I discovered out that the new friction mount
    for the 2557 would not perform with the 205W (according to
    Garmin), but the old friction mount for the 205W or the new 1 will operate with the 2557.

  17. Aw, this was a really good post. Finding the
    time and actual effort to create a top notch article… but what can I say… I procrastinate
    a whole lot and never manage to get nearly anything done.

  18. I don’t know if it’s just me or if perhaps everybody else experiencing issues with your website.
    It appears like some of the text on your content are running off the screen. Can someone
    else please provide feedback and let me know if this is happening to them too?

    This might be a problem with my web browser because I’ve had this happen previously.
    Kudos

  19. Humana People to People creates their mission to strengthen under-developed countries by providing instruction to primary school instructors and tradesmen, assisting to advocate
    well being and distribute information about Aids and to support in further rising the
    areas farming. Humana People to People has a variety of different projects and tasks all over poor areas of countries worldwide.
    Through employing the local persons and their governing administration,
    they can help individuals who’re short of funds through their non-profit help agencies.

    China is one kind of various nations that this non-profit institution goes to experience the pushing problems
    that they confront today.
    The Humana People to People Motion works together with The Federation for Groups from the Yunnan area in China.
    The project started within 2005 and remains around today.
    The Humana People to People Association Work Department in the Yunnan Region functions to grow money to help run numerous plans through the entire region in poverty-stricken places.
    Some plans which Humana People to People aims to bring to the section of China involve
    vocational coaching centers where there’re able to further
    their education, organizing them to get work opportunities,
    supplying information about infected diseases and many more.

    Humana People to People first began implementing their
    developments within China during 2007. One of the primary projects that was
    assumed was the Malaria mission which directed to deliver worthwhile details and avoidance about the sickness to locale individuals.
    A Community Capability Advancement and Child Aid project was
    then began in Zhenkang. A fantastic 13 plans were initiated in 2010 for several of the
    largest poverty-stricken regions of the area. Besides the Yunnan Province, plans were pointed in the
    Sichuan Area, Chongqing Province and Guangdong Province.

    Now, some tasks that Humana has assumed within China
    involves attention in rural regions, early childhood schooling which is created to give Chinese kids a lead on the way to success,
    generating safer paths for Humana toddler kids, giving speedy HIV checking, starting grower organizations and raising cash through
    charity events for example the Comedy Pub China Nonprofit Demonstrate.
    At present, there are 11 developments increasingly being completed across 3
    provinces within China as well as in over 128 communities.
    With 280 cumulative beneficiaries, People
    to People delivers wish and also a better future to those
    poverty-stricken countryside areas.

  20. When people see how behaved kids are, they will have no problems, having them, but when they see kids that
    don’t know how to behave, they are quick to give them
    back to their parents, and they don’t want nothing to do with the kids.
    It bothers me when I hear parents using profanity around their kids.

    Effectively they have a huge collection of videos and photographs, they’re
    nicely respected inside the t-girl porn globe plus they update the web page on a continual
    basis.

  21. Many skate parks are privately held whereas numerous other
    individuals are combined with metropolis parks and preserved by the town federal government.
    The BMX industry as a whole has become more popular in the past 20 years and due
    to that the game is much more cost effective for break into
    then it was in the past. You might actually end
    up losing more money when you opt for these cheap models.

  22. Thank you for every other informative blog. The place else could I am getting
    that type of info written in such an ideal manner?
    I’ve a undertaking that I am just now working on, and
    I’ve been at the look out for such info.

  23. A hardly any exercise offering 000-N23 web sites guarantees the best focused conclusion in Ibm 000-N23 review.

    Don’t demand our thought for that easy this useful time payments
    software is to depend on. Bespoke software incredible
    evolution offers flexibility, control then customization.

  24. What’s Happening i am new to this, I stumbled upon this I’ve discovered
    It absolutely useful and it has helped me out loads. I’m hoping to contribute & help different customers like its helped me.
    Great job.

  25. Aw, this was a really good post. Finding the time and actual effort to make a very good article… but what can I
    say… I put things off a lot and don’t seem to get anything done.

  26. Please let me know if you’re looking ffor a article writer
    for your weblog. You have som really good posts annd I feel I would be a good asset.
    If you ever want to take some of the load off, I’d love to write some content for your blog in exchange for a link bzck too
    mine. Please send me an emaill if interested.
    Many thanks!

  27. Simply wish to say your article is as surprising.
    The clearness in your submit is just nice and that i can assume you’re knowledgeable in this subject.
    Well together with your permission let me to grasp your feed to
    keep up to date with forthcoming post. Thanks a million and please carry on the rewarding work.

  28. I like the helpful information you supply on your articles.
    I will bookmark your blog and test again here frequently. I am rather certain I will be informed plenty of new stuff proper right here!
    Best of luck for the next!

  29. Great web site. Plenty of helpful information here.
    I’m sending it to several pals ans also sharing in delicious.
    And obviously, thank you in your sweat!

  30. No matter if some one searches for his necessary thing, therefore he/she needs to be available
    that in detail, therefore that thing is maintained over here.

Leave a Reply

Your email address will not be published. Required fields are marked *


8 + eight =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>