Removing Excel database links from master mailmerge Doc

[lionelnz]

Good morning all from NZ.

I have a master doc linked to a SS database and every now and then server administrators and managers move folders around upsetting the links.

When I opened the document it hung looking for the link and I had to copy folder back to original place then re-link the SS to the master doc.

Once upon a time there was the option to remove all links and leave the master doc as a template.

This no longer appears to be the case.

So how do I remove links but leaving a clean master doc?

I am using Office 2013 on Windows 7 on a server.

 

[Worf]

Good evening

1. With the Word document open, click the ‘Mailings’ tab
2. Click on the ‘Start Mail Merge’ button
3. Then click on ‘Normal Word Document’
4. Save and close the document– the link to the data source has now been removed.

 

[Macropod]

Simply open the document and answer 'No' at the SQL prompt. Having done that, you can re-connect the document to the data source. Do note that once you disconnect from the data source, whether by this method or that suggested by Worf, you will lose any mailmerge filters that may have been applied; these will need to be re-established before the mailmerge will work the same way as before.