mail merge re-establish links
i have an excel macro sheet that contain a button . It consolidate the data from other sheets to a main sheet in the excel.
After have a mail merge template V2016, that take data from the excel like name, address, phone to create the letters.
The documents (mail merge template & macros) are in a share drive.
When i use it .. the excel & merge works ok i set up the link only once.
But when someone else use the document via the share folder then i need to re-establish all the links & conditions in the mail merge template for user & myself. links lost.
how can this link be set up at once for multiple users in share drive?