I used Word to create a Label mail merge to create labels from an .xlsm file.



I saved the mail merge as a template.


If I don't make any changes to the .xlsm file, when I can open the template, I get a pop up "Opening this document will run the following SQL command....".


I click on "Yes", navigate to the .xlsm file, click on it, and everything works.


The problem occurs when I make a change to the .xlsm file.


I find when I open the template, I get the popup, I still navigate to the .xlsm file and click on it. But then, instead of the template opening, it goes back to the popup.



I have to close the popup window, then the template opens, and I have to again select the .xlsm file (via the Select Recipients menu).


At this point, I can do the Preview and Update.


If I don't go through the procedure of selecting the .xlsm file twice. It doesn't work. The Preview and/or Update will be grayed out.


Is that the way it is suppose to work, or am I doing something wrong? It seems awfully convoluted.