What’s new in Access 2013 for developers

Mike Stowe, Programming Writer, Office Developer Documentation team, authored today's post. Access 2013 features a new type of application model, Access apps, that’s makes it easy to create, customize, and deploy an app to the cloud.

Read the rest here: 
What’s new in Access 2013 for developers

Microsoft unveils the new Office

SAN FRANCISCO — July 16, 2012 — Today, Microsoft Corp. CEO Steve Ballmer unveiled the customer preview of the new Microsoft Office, available at office.com/preview . The next release features an intuitive design that works beautifully with touch, stylus, mouse or keyboard across new Windows devices, including tablets.

Originally posted here: 
Microsoft unveils the new Office

A Professional Developer’s Intro to the Office Development Platform

Thanks to everyone attended my sessions at Tech Ed North America and at SharePoint TechFest. It was a lot of fun and everyone had great questions. This type of session is a challenge due to the plethora of overlapping technologies involved.  Hopefully, the session did as advertised:

 

Provide an understanding of the developer technologies provided by the Office platform and explain when to use each technology.

You will leave here with an understanding of when to use Office technologies like Open XML, VSTO, SharePoint Document Services (Word, Excel, Visio), SharePoint REST API & Client Object Model, Business Connectivity Services, etc., and how to build them.

I have attached the slide deck and the demo code to this post. As a I mentioned at the beginning of the session, the MSDN Office Developer Map is a great place to go to find content related to any Office Development task. Here is the link:

http://bit.ly/OfficeDevMap

The session deck has even more links and I’ll post a ton of material so be sure and check those out as well.

 

Download the files here.

The Asus Eee Slate is Compelling

I’m ready to get my hands on the the Asus Eee Slate. I think I could get into that. Channel 9 has a video that shows how Asuss + Office 2010 will work. It looks good to me.

It isn’t an iPad but I don’t want it to be. I want to be a table/slate-based PC. Highly portable and highly productive.

 

 

I wonder what impact the Eee Slate will have on Office Development.

When I have my grubby hands on the Eee slate, I plan to find out.

Using SharePoint Business Connectivity Services to Expose Line of Business Data: Tyson Developer’s Conference

I wanted to thank everyone who came out to my presentation. Here is a link to the slide deck:

Using SharePoint Business Connectivity Services to Expose Line of Business Data

Building Business Applications with SharePoint 2010 and Office 2010: Presentation from Tyson Developer’s Conference

I wanted to thank everyone who came out to my presentation. Here is a link to the slide deck as well as a link to the source code.

PowerPoint
Building Business Applications with SharePoint 2010 and Office 2010

Source Code
Nortwind Office Business Application


Xobni Sets Its Sights on the Enterprise

I’ve been waiting for this one for awhile. I’m a fan of Xobni and have found it to be a useful addition to my Outlook inbox. I have enjoyed Xobni’s integration with Facebook, Twitter, and LinkedIn. I find it interesting, if not useful, to quickly see what the person who sent me an email has had to say in the social realm. It helps me understood who they are, etc.

Despite Xobni integration with these tools they lack integration with other key technologies that I use on a daily basis…like Microsoft SharePoint. Also, Xobni has not been an open platform for developers. SDK and other tools to allow developers to extend Xobni have not been available…until now.

xobni

Xobni Enterprise

Xobni enterprise provides organizations with the ability to deploy the Xobni Outlook client and centrally manage the features available to employees. The server component is accessible through an admin web site. Via the admin portal, you can control deployment to groups of Active Directory users. You can also activate/deactivate Xobni Enterprise features.

Xobni Enterprise includes features for end-users as well. For example:

  • AutoSuggest
  • Advanced Filtering
  • Unlimited PSTs
  • Appointments and Tasks

Xobni Developer SDK

With Xobni Enterprise arrives a Xobni SDK for anyone that wants to extend Xobni. From reading their press release, it looks like integration with just about any type of application will be possible.

OfficeDeveloper Now on Twitter

I’m thinking this Twitter thing just might catch on with people…

I now have a Twitter account that goes with this blog.

http://twitter.com/OfficeDeveloper

 

twitter

Build a Collapsible Task Pane in Outlook – Part 2

In part 1 of this series I gave a (brief) overview of the Outlook Task Pane and provided a couple of links to articles on MSDN that explain how to build one.

Recap – 2 Problems with Task Panes within Outlook

Building a task pane and displaying it within Outlook is easy but as I mentioned in Part 1, there are a couple of problems:

  1. Managing the multiple Task Pane instances, attaching to the Explorer and Inspector windows, and destroying each task pane when its Explorer or Inspector windows closes can be a pain.
  2. The task pane you build does not come with an “collapse” button. You know, the button with a couple of chevrons pointing in the direction it will collapse? You have to add this functionality yourself. It can be done but there are easier methods.

This brings me back to the point of this series, Add-In-Express 2009 (ADX). This tool takes care of Issue #1 and. Issue #2. Yes, ADX costs a few bucks but it’s a time-saver and it reduces development effort. Either one of those is typically reason enough for me to purchase a tool (especially if the client is paying for it).

Quick Overview of the Design for the Collapsible Task Pane

By collapsible, I mean it can be "minimized" so that it resembles the collapsed state of the ToDo Bar. The task pane has a “collapse” button and resides between the mail preview window and the ToDO bar within Outlook Explorer windows.

Here is the design for the sample add-in I will build in Part 3:

Outlook_open

The task pane displays exactly where it should. You can see the collapse button on the upper right-hand corner of the task pane. When the user clicks that button, they will see something like this image:

Outlook-collapsed

In this collapsed-state, only a vertical bar displays with an “expand” button. Clicking the expand button will return the task pane to its open state.

Preview of Part 3

Next-up, I’ll dig into the code and actually build the add-in. Also, I’ll decide on what to display within the task pane besides a lame button. Not to worry, I’ll think of something useful to put there and it will be code you can steal…put to use today.

Build a Collapsible Task Pane in Outlook – Part 1

I believe Outlook is the informational portal to business users everywhere. As the desktop interface to Microsoft Exchange, Outlook effectively serves as the short-term and long-term memory of the individual user…the brain if you will. I feel comfortable calling Outlook my brain as I have only a limited short-term memory and virtually no long-term memory.

If I don’t get an important date on the Outlook Calendar or create a task for something I need to do…forget it. It won’t happen. If I delete an email instead of filing it away within my insanely intricate and highly detailed filing system, it is like you never emailed me at all.

My point, is Outlook contains the details of my life…both professionally and personally. It is vital to what I do and how well I do it. I’m obsessed with keeping my information organized and using this order to execute on a daily basis. I’m not what you might call “anal”. I don’t naturally have orderly tendencies. This fact only serves to point out the genius that is Outlook.

Outlook Provides Developers With a Portal to Business Users

As a developer, my love for Outlook has only increased. The Outlook object model is extensive, allowing developers to build Outlook add-ins that automate the workflow and info-flow (best I can tell, I just coined that phrase…I claim it) of their users.

When Microsoft released Outlook 2007, I was immediately drawn to the integration of the ToDo Bar into the main email window (see below).

outlook-displaying-todo-taskpane

I love that I can view my upcoming appointments along with my task list in the same window that I manage email. Ever since I first saw the ToDo Bar, I wanted to build a similar type of task pane. I found that it is indeed possible but it is a complete PITA. The issue comes down to manage your custom task pane instances and tracking to which Outlook Explorer or Outlook Inspector window they belong.

You can do manage the task panes by following the guidance available here:

Walkthrough: Displaying Custom Task Panes with E-Mail Messages in Outlook

Or you can take an easier approach and download the VSTO Power Toys and make use of the Office Custom UI Manager. Either way, write code to manage the task panes. In fact, I wrote about it in my book, Pro Office 2007 Development with VSTO.

Task Panes Made Easy with Add-In-Express

Both of the example just mentioned make building & managing custom Outlook task possible. But an much easier method exists. In fact it requires virtually no code. The rub is you need to look beyond the toolset provided by Microsoft. This tool is Add-In-Express 2009 (there are two versions, one for VSTO-based solutions and another for COM-based solutions)

Add-In-Express (ADX) can handle it all, allowing you build custom CommandBars, Ribbons, Outlook Property Pages, Form Regions, and much much more. In fact, they extend the possibilities of such things like form regions, allow you to place them in other locations besides the bottom of an Outlook form (see below):

outlook-regions[1]

(Source: Add-In-Express.com)

I first discovered ADX when building a solution for one of the major banks in the USA. That project required that we integrate Outlook with a custom CRM solution involving Exchange, Oracle, and Java web services. Using ADX, I was able to quickly build out the required Outlook Task Panes.

A Preview for Part 2

That’s it for now. I decided to break this article up into a series of posts. I originally planned to cover it all in a single post but kept procrastinating because I didn’t want to write a full-fledged article in a single sitting. So I’ll stop here with a quick intro of Outlook task panes and Add-In-Express. In, Part 2 of this series, I’ll cover the design for a sample add-in that will serve as the basis for a solution I’ll create with Add-In-Express 2009.