Mail merge with documents in SharePoint as data source

[Yorick]

We are trying to create a mail merge using a document in SharePoint as the
data source. When linking the document as data source to the main document we
browse to the SharePoint document library using the My Network Places and
select the document. After clicking OK, Word presents the "This file could
not be found" error message.

Does anyone know if this can be done any other way??
We do not have the possibility to use file servers for this, so it must be a
way to use SharePoint somehow.

Regards,

Yorick

 

[Peter Jamieson]

I do not know for sure, but I suspect this problem is related to the one
where you cannot use a data source located at an Internet URL (such as an
http: or ftp: address).

Can you assign a drive letter to the document library? If so, you may be
able to do what you want. If not, I suggest you contact MS Support directly
and ask them whether or not it can be done, and if so, how.

Peter Jamieson

 

[dottiemay]

I've noticed that it doesn't like the internet URL as Peter has indicated. I
usually copy the file path I need (or retype it) and eliminate the http://
portion and precede it with two back slashes \\. That usually works for me.
In other cases, I've mapped a drive letter to the portal library.

 

[Yorick]

That was what I noticed as well.
But how do you create a mapping to a SharePoint site or document library.
Both the My Network Places and the "Map Network Drive" refuse to create a
network mapping to a http source.

Yorick

 

[John Whiteley]

Link Concepts mail merge web part allows you to merge SharePoint Contact list data into Word templates, the merged document can be printed or sent as an attachment to email. The body text of the email can als be merged with Contact list data to create a personalized email, ideal for email marketing campaigns.

Please visit our demo site - http://sharepoint.linkconcepts.co.uk - and try mail merge for yourself, the site has anonymous access but you can log in using linkguest and the username and password.

Currently we offer a free 15 day trial for you to evaluate the web part functionality on your own SharePoint server, 2007 & 2010 versions are both supported.

Kind Regards

John W