Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2020, 11:17 PM
JeffL JeffL is offline Problem using a mailmerge template with new file Windows 8 Problem using a mailmerge template with new file Office 2013
Novice
Problem using a mailmerge template with new file
 
Join Date: Dec 2013
Location: North Hollywood, CA
Posts: 6
JeffL is on a distinguished road
Default Problem using a mailmerge template with new file

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.
Reply With Quote
  #2  
Old 09-07-2020, 04:48 AM
gmayor's Avatar
gmayor gmayor is offline Problem using a mailmerge template with new file Windows 10 Problem using a mailmerge template with new file Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,407
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
Default

See the Word macro to toggle the registry setting used by the SQL security warning at the end of Word VBA examples.

Rather than save the label merge document as a template, save it as a document (docx format)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 09-07-2020, 03:33 PM
JeffL JeffL is offline Problem using a mailmerge template with new file Windows 8 Problem using a mailmerge template with new file Office 2013
Novice
Problem using a mailmerge template with new file
 
Join Date: Dec 2013
Location: North Hollywood, CA
Posts: 6
JeffL is on a distinguished road
Default

Thanks for the reply, but I just discovered an interesting turn of events. I was having the problem on my Desktop computer running Word 365. When I run it on my Notebook running Office 2013, it works in a rational way.

The difference is, when I open the template on my Notebook, I get the SQL popup, but clicking on YES takes me right to the Mail Merge screen where I can select any Recipient .xlsm file, and everything works fine.

When I open the template on my Desktop, I get the SQL popup, but when I click YES, instead of displaying the Mail Merge screen, it opens Windows Explorer, showing Connect to New Data Source and NewSQLServerConnection. If, at this point, I do not navigate to the .xlsm source file and select it. I get the failure described in my original post.
Reply With Quote
  #4  
Old 09-07-2020, 04:32 PM
JeffL JeffL is offline Problem using a mailmerge template with new file Windows 8 Problem using a mailmerge template with new file Office 2013
Novice
Problem using a mailmerge template with new file
 
Join Date: Dec 2013
Location: North Hollywood, CA
Posts: 6
JeffL is on a distinguished road
Default

Quit looking! I didn't find the problem but I fixed it.

I did what I had to to get the Mail Merge to open, then I saved it as another template (maybe I could have just saved it, but the name was misspelled anyway).

Well, lo and behold, when I open the new template, it goes right to the Mail Merge screen, no SQL check, and no Windows Explorer data source window.
Works on both PCs.

Yay!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem using a mailmerge template with new file how to make a template with field and mailmerge to work together in protected mode pjkon Mail Merge 1 06-10-2019 04:35 PM
Problem using a mailmerge template with new file MailMerge from txt file - failing when the file path contains a reserved SQL word travb81 Word VBA 7 10-26-2018 04:00 AM
Problem using a mailmerge template with new file Mailmerge Excel with a Master Word Template (via VBA) stevenel Excel Programming 8 08-14-2018 03:05 PM
Problem using a mailmerge template with new file Template From MailMerge Document LouGibson Mail Merge 1 06-13-2016 03:14 PM
Mailmerge problem in 2010 dsouter Mail Merge 0 06-19-2010 05:27 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft