Wednesday, July 18, 2007

Mail Merge and Microsoft Office SharePoint Server 2007

In Word 2007 you have the possibility to merge a document template with data from a data source, creating for example a mailing very easily. The data source can be various types of documents, like Excel, Word or Access files. But it turns out that Word 2007 cannot handle data source documents on an http location.

When opening a mail merge template document and you try to connect a source document which is located on a SharePoint site (Mailings > Select Recipients > Use Existing Lists > My Network Places > Select document on SharePoint site), Word 2007 gives the error message “This file could not be found”. A workaround is to download the source document to the local computer (for example the desktop) and connect it there. The downside is that you have to download the document each time you want to do a mail merge.

Hopefully this issue will be fixed in the next Office Service Pack.


deanna said...

I am on SharePoint 2010 and Office 2010 is there a solution to this yet? I am getting the same error message as in 2007.

Yorick said...

Hi Deanna,

I haven't tested this under SP2010/Office 2010 yet, but if you experience the same behaviour, I am afraid that the issue still exists.