Hello,

Every month I create about 10 letters using the same data: date, address, company name etc, but each of them is intended for sending to another kind of recipient and contains different text.



I thought that the best solution would be to create an excel database with data that are repeated and combine it with the text in the templates. I prepared such templates and linked them. Unfortunately, interrupting the link require to edit each letter and delete all links manually. Is there any possibility of interrupting links using macro?

I enclose the database and an example of one letter. Thanks for any idea.

Attached Files

	Dane.xlsm (17.2 KB, 13 views)
	Letter.docx (24.6 KB, 12 views)