Using Word to Create Master-Detail Reports for LightSwitch (or Silverlight)

A while back a posted how to use Word to create simple reports for LightSwitch by passing in an entity (like Customer) and using Word Content Controls to lay out content in a template and bind them to XML inside the document. If you missed it: Using Microsoft Word to Create Reports For LightSwitch (or… Read more

How To Send HTML Email from a LightSwitch Application

A while back Paul Patterson wrote an awesome step-by-step blog post based on a forum question on how to send an automated email using System.Net.Mail from LightSwitch. If you missed it here it is: Microsoft LightSwitch – Send an Email from LightSwitch This is a great solution if you want to send email in response… Read more

Using Microsoft Word to Create Reports For LightSwitch (or Silverlight)

Note: This post has been updated for Beta 2 on 3/24/2011 LightSwitch has a really nice feature on data grids that allow you to export them to Excel if running as a Desktop application (out of browser). This gives you a basic way of getting data out of the system to create reports or do… Read more

I’m Alive and Back from DevDays & TechDays Europe

Jet lag, busy, busy, busy, busy, busy. That’s been my week so far preparing all the awesome content we have in store for you for Monday’s Visual Studio 2010 launch! Unfortunately this week has also taken me away from blogging and I have some fun stories from DevDays Netherlands and TechDays Belgium where I spoke… Read more

Open XML SDK 2.0 Released!

Many programs that need to process documents often require manipulation of the file formats directly and doing that through the Office component object model (COM) won’t scale very well. It also requires that Microsoft Office be installed to run. A better route in a lot of these cases is to use the Open XML SDK…. Read more

Silicon Valley Code Camp Oct. 3-4 : Schedule is up!

As I mentioned before, I’ll be speaking this weekend at Silicon Valley Code Camp ( This is a FREE event at at Foothill College and it’s not just Microsoft technologies. A lot of great speakers will be there too. The schedule is up so check it out and mark the ones you plan on attending…. Read more

Merging Text & Photos into a Word Document using Open XML SDK

Yesterday I posted about how we could create a letter generator (mail merge) that took data from a database to create a Word 2007 document using the System.IO.Packaging class. I showed how to take data from Northwind using a single LINQ query to create XDocument objects representing letters to customers and then create a single… Read more

Mail Merging Into a Single Word Document Using XML Literals

With the release of Microsoft Office 2007 we can work with a much simpler, standard, XML format called Open XML which opens the door for many types of applications that cannot work via COM. What if you needed to build a scalable web service that processes many documents in high volume? What if you wanted… Read more

DevProConnections Article: Taking Advantage of LINQ and XML in Microsoft Office 2007

This month I have an article on DevProConnections: Taking Advantage of LINQ and XML in Microsoft Office 2007 In this article, I talk about how a lot of applications that need to take advantage of Microsoft Office can do so without going through COM. Many programs that need to process documents often require manipulation of… Read more

Using Windows Presentation Foundation in Office Clients

I was cleaning up my desk today and in the piles of mail and gobs of paper I found the SDN Magazine “Women in Technology” issue 101 that featured an article I wrote that was released in print back in May. Well, I just noticed today that near the end of June they made most… Read more