Thread: [Solved] Deleting link using macro
View Single Post
 
Old 09-13-2018, 02:02 PM
karpinsky karpinsky is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2018
Posts: 3
karpinsky is on a distinguished road
Default Deleting link using macro

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
File Type: xlsm Dane.xlsm (17.2 KB, 13 views)
File Type: docx Letter.docx (24.6 KB, 12 views)
Reply With Quote