The exact Registry key varies, depending on the version of Word, but follows the pattern HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options This is described in the Knowledge Base article about the prompt. Change the Registry setting to disable the prompt.These, in double-quotes, are assigned to the Name, SQLStatement and Connection parameters of. Then ?Īfter pressing Enter for this one you should see something along the lines of Provider=.12.0 User ID=Admin Data Source=C:\Users\\Documents\Personal\Text.mdb Mode=Read Extended Properties="" Jet OLEDB:System database="" Jet OLEDB:Registry Path="" Jet OLEDB:Engine Type=5 Jet OLEDB:Database Locking Mode=0 Jet OLEDB:Global Partial Bulk Ops=2 Jet OLEDB:Global Bulk Transactions=1 Jet OLEDB:New Database Password="" Jet OLEDB:Create System Database=False Jet OLEDB:Encrypt Database=False Jet OLEDB:Don't Copy Locale on Compact=False Jet OLEDB:Compact Without Replica Repair=False Jet OLEDB:SFP=False Jet OLEDB:Support Complex Data=False Jet OLEDB:Bypass UserInfo Validation=False In Word, in the Immediate Window ( Ctrl+ G) of the VBA Editor enter the ? lines and press Enter, one-by-one: ?Ĭ:\Users\Cindy Meister\Documents\Personal\klpFeb00.mdb In order to figure out the necessary syntax, you can either record a macro while connecting to the data source (this is most certain and fastest), or you can query the data source from the document before disconnecting it.
#HOW TO ACTIVATE MERGE AND CENTER IN EXCEL CODE#
Add a line to your code that links in the data source before executing the mail merge. The data source can be removed from the document by choosing the option to open the document without allowing the mail merge (the button labelled "No" in the version of Word I'm looking at). If the user allows the VBA to run, then supposedly the entire project is trusted, so attaching the data source using code is allowed.
The advantage to this approach is that it upholds Word's security setting.
Remove the data source from the main merge document, then add it explicitly using VBA every time document is opened.The prompt ensures that the user is aware of this and (supposedly) only runs the mail merge if the document is from a "trusted source". Note that the prompt is a security measure since the SQL a mail merge runs could cause harm to a system. There are two basic approaches that can be used to run a mail merge without triggering the prompt.
Wouldn't it better to use early bind of the word object? Set wdDoc = GetObject(MMFileName, "Word.document")Īlso all of the examples I have seen use late binding. How do I get this to work? Public Sub RunMailMerge(MMFileName As String) When run Word opens and I get the same prompt. I put together the following code from examples on this forum but is not working. What I want to do is have the Excel spreadsheet run the mail merge without any user intervention when I click a button. When I open the word doc I get a prompt that says "Opening this document will run the following SQL command", etc, etc. I have a Word mail merge document that is all set up to run. I have a spreadsheet that has data that is used in a MS mail merge.
#HOW TO ACTIVATE MERGE AND CENTER IN EXCEL UPDATE#
I know this has been asked before and I tried to update the other thread but was not allowed.
0 kommentar(er)
