Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
In 2003 I could use INCLUDETEXT to call another document or documents into a
'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
SorrentoBob,
Try making the source documents a trusted location(s) in Word Options. "SorrentoBob" wrote in message ... In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Thanks, Jules.
By source doccuments do you mean the documents the master is calling in or the master? Unfortunately I won't be able to test this until I get back to a computer with 2007! -- Thanks, SorrentoBob "Jules" wrote: SorrentoBob, Try making the source documents a trusted location(s) in Word Options. "SorrentoBob" wrote in message ... In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Is the message that you are getting
"Opening This Will Run the Following SQL Command" If so, see the following Knowledge Base article: http://support.microsoft.com?kbid=825765 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "SorrentoBob" wrote in message ... In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Doug,
Thanks. The resource you sent me to leaves me puzzled. The site says there is a work around but it involves compromising security. In short, there is no safe way to run a merge in 2007 that invokes other documents. Since the merge stops for EVERY record and displays that message, WORD 2007 mail merge cannot be safely used to do this kind of merge. I have built literally hundreds of complex merges for schools all over the country in pre-2007 versions that use that capability perfectly without styopping at every recoird. How sad...and strange. -- Thanks, SorrentoBob "SorrentoBob" wrote: In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Hi SorrentoBob,
The only reason the other computers to which you refer might not already have been getting the prompts is that they're using Word 2000 or earlier, or their copies of Word 2002 & 2003 weren't up-to-date. The mods referred to in the article merely stop the 'SQLSecurityCheck' thus restoring the security level to what it was before the patch that introduced the prompt was applied. -- Cheers macropod [MVP - Microsoft Word] "SorrentoBob" wrote in message ... Doug, Thanks. The resource you sent me to leaves me puzzled. The site says there is a work around but it involves compromising security. In short, there is no safe way to run a merge in 2007 that invokes other documents. Since the merge stops for EVERY record and displays that message, WORD 2007 mail merge cannot be safely used to do this kind of merge. I have built literally hundreds of complex merges for schools all over the country in pre-2007 versions that use that capability perfectly without styopping at every recoird. How sad...and strange. -- Thanks, SorrentoBob "SorrentoBob" wrote: In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Thanks, Macropod,
In earlier versions than 2007 that prompt always appeared, but onlynce when I opened the master document, but bever once again for each record. In myu work that could be hundredss of times to get the merge done. By the way, the prompt does not appearf for each record if the documents inserted by INCLUDETYEXT have not been associated with the data file (because they have no merge fields iun them). So, if I understand your info, resetting the secuirty will not remove all security but just an additional level...and the prompt will never appear, even for the master document? Thanks, again! -- Thanks, SorrentoBob "macropod" wrote: Hi SorrentoBob, The only reason the other computers to which you refer might not already have been getting the prompts is that they're using Word 2000 or earlier, or their copies of Word 2002 & 2003 weren't up-to-date. The mods referred to in the article merely stop the 'SQLSecurityCheck' thus restoring the security level to what it was before the patch that introduced the prompt was applied. -- Cheers macropod [MVP - Microsoft Word] "SorrentoBob" wrote in message ... Doug, Thanks. The resource you sent me to leaves me puzzled. The site says there is a work around but it involves compromising security. In short, there is no safe way to run a merge in 2007 that invokes other documents. Since the merge stops for EVERY record and displays that message, WORD 2007 mail merge cannot be safely used to do this kind of merge. I have built literally hundreds of complex merges for schools all over the country in pre-2007 versions that use that capability perfectly without styopping at every recoird. How sad...and strange. -- Thanks, SorrentoBob "SorrentoBob" wrote: In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Hi SorrentoBob,
Its not so much that there are INCLUDETEXT fields or MERGEFIELDS in the linked documents that is the problem, but that that linked documents are (re)triggering the SQL. As I understand it, a mailmerge that doesn't use SQL statements, including in the linked documents, won't generate the warning. As for the effect of resetting the secuirty, that's how I read the article. In any event, you could reset the 'SQLSecurityCheck' value - presumably '00000001' would reactivate it. If you're using vba in your main mailmerge document, this opens up the possibility of setting/resetting the key just for the duration of the mailmerge. -- Cheers macropod [MVP - Microsoft Word] "SorrentoBob" wrote in message news Thanks, Macropod, In earlier versions than 2007 that prompt always appeared, but onlynce when I opened the master document, but bever once again for each record. In myu work that could be hundredss of times to get the merge done. By the way, the prompt does not appearf for each record if the documents inserted by INCLUDETYEXT have not been associated with the data file (because they have no merge fields iun them). So, if I understand your info, resetting the secuirty will not remove all security but just an additional level...and the prompt will never appear, even for the master document? Thanks, again! -- Thanks, SorrentoBob "macropod" wrote: Hi SorrentoBob, The only reason the other computers to which you refer might not already have been getting the prompts is that they're using Word 2000 or earlier, or their copies of Word 2002 & 2003 weren't up-to-date. The mods referred to in the article merely stop the 'SQLSecurityCheck' thus restoring the security level to what it was before the patch that introduced the prompt was applied. -- Cheers macropod [MVP - Microsoft Word] "SorrentoBob" wrote in message ... Doug, Thanks. The resource you sent me to leaves me puzzled. The site says there is a work around but it involves compromising security. In short, there is no safe way to run a merge in 2007 that invokes other documents. Since the merge stops for EVERY record and displays that message, WORD 2007 mail merge cannot be safely used to do this kind of merge. I have built literally hundreds of complex merges for schools all over the country in pre-2007 versions that use that capability perfectly without styopping at every recoird. How sad...and strange. -- Thanks, SorrentoBob "SorrentoBob" wrote: In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
macropod wrote:
If you're using vba in your main mailmerge document, this opens up the possibility of setting/resetting the key just for the duration of the mailmerge. Having opened up that possibility and given that it is too hot and humid here to provide the inclination to go out on an August Saturday afternoon - how about Sub ToggleSQLSecurity() Dim WSHShell, RegKey, rKeyWord, wVer Set WSHShell = CreateObject("WScript.Shell") wVer = Application.Version If wVer 10 Then MsgBox "This macro is for Word 2002 and later!", vbOKOnly, "Wrong Word Version" Exit Sub End If Start: RegKey = "HKEY_CURRENT_USER\Software\Microsoft\Office\" & wVer & "\Word\Options\" On Error Resume Next 'The registry key does not exist rKeyWord = WSHShell.RegRead(RegKey & "SQLSecurityCheck") If rKeyWord = "" Then 'if the added key has no number WSHShell.regwrite RegKey & "SQLSecurityCheck", 1, "REG_DWORD" 'set it at zero GoTo Start: 'and read it again End If If rKeyWord = 1 Then WSHShell.regwrite RegKey & "SQLSecurityCheck", 0, "REG_DWORD" Else WSHShell.regwrite RegKey & "SQLSecurityCheck", 1, "REG_DWORD" End If End Sub This will create and/or toggle the SQL Security Check registry key and will work with any Word version -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
too hot and humid here to provide the inclination to go out on an August Saturday afternoon
Ah, what a difference a hemisphere makes. I'm staying inside 'cause it's too cold to stay outside. -- Cheers macropod [MVP - Microsoft Word] "Graham Mayor" wrote in message ... macropod wrote: If you're using vba in your main mailmerge document, this opens up the possibility of setting/resetting the key just for the duration of the mailmerge. Having opened up that possibility and given that it is too hot and humid here to provide the inclination to go out on an August Saturday afternoon - how about Sub ToggleSQLSecurity() Dim WSHShell, RegKey, rKeyWord, wVer Set WSHShell = CreateObject("WScript.Shell") wVer = Application.Version If wVer 10 Then MsgBox "This macro is for Word 2002 and later!", vbOKOnly, "Wrong Word Version" Exit Sub End If Start: RegKey = "HKEY_CURRENT_USER\Software\Microsoft\Office\" & wVer & "\Word\Options\" On Error Resume Next 'The registry key does not exist rKeyWord = WSHShell.RegRead(RegKey & "SQLSecurityCheck") If rKeyWord = "" Then 'if the added key has no number WSHShell.regwrite RegKey & "SQLSecurityCheck", 1, "REG_DWORD" 'set it at zero GoTo Start: 'and read it again End If If rKeyWord = 1 Then WSHShell.regwrite RegKey & "SQLSecurityCheck", 0, "REG_DWORD" Else WSHShell.regwrite RegKey & "SQLSecurityCheck", 1, "REG_DWORD" End If End Sub This will create and/or toggle the SQL Security Check registry key and will work with any Word version -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Hi SorrentoBob,
An alternative would be to ensure all your SQLs and MERGEFIELDs are in the main document. If you've got a MERGEFIELD in the linked document, the way to do this is to bookmark all of the linked document's text before & after each MERGEFIELD (one more bookmark than the number of MERGEFIELDs will be needed) and move the MERGEFIELDs to the main document. In the main document, make multiple copies of your INCLUDETEXT fields and point them to the relevant bookmarks in the linked docuument. That way, even without the registry change, you should get no SQL prompts at all. -- Cheers macropod [MVP - Microsoft Word] "SorrentoBob" wrote in message news Thanks, Macropod, In earlier versions than 2007 that prompt always appeared, but onlynce when I opened the master document, but bever once again for each record. In myu work that could be hundredss of times to get the merge done. By the way, the prompt does not appearf for each record if the documents inserted by INCLUDETYEXT have not been associated with the data file (because they have no merge fields iun them). So, if I understand your info, resetting the secuirty will not remove all security but just an additional level...and the prompt will never appear, even for the master document? Thanks, again! -- Thanks, SorrentoBob "macropod" wrote: Hi SorrentoBob, The only reason the other computers to which you refer might not already have been getting the prompts is that they're using Word 2000 or earlier, or their copies of Word 2002 & 2003 weren't up-to-date. The mods referred to in the article merely stop the 'SQLSecurityCheck' thus restoring the security level to what it was before the patch that introduced the prompt was applied. -- Cheers macropod [MVP - Microsoft Word] "SorrentoBob" wrote in message ... Doug, Thanks. The resource you sent me to leaves me puzzled. The site says there is a work around but it involves compromising security. In short, there is no safe way to run a merge in 2007 that invokes other documents. Since the merge stops for EVERY record and displays that message, WORD 2007 mail merge cannot be safely used to do this kind of merge. I have built literally hundreds of complex merges for schools all over the country in pre-2007 versions that use that capability perfectly without styopping at every recoird. How sad...and strange. -- Thanks, SorrentoBob "SorrentoBob" wrote: In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
Cold I could do without, but a few weeks of rain would be more than welcome
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: too hot and humid here to provide the inclination to go out on an August Saturday afternoon Ah, what a difference a hemisphere makes. I'm staying inside 'cause it's too cold to stay outside. "Graham Mayor" wrote in message ... macropod wrote: If you're using vba in your main mailmerge document, this opens up the possibility of setting/resetting the key just for the duration of the mailmerge. Having opened up that possibility and given that it is too hot and humid here to provide the inclination to go out on an August Saturday afternoon - how about Sub ToggleSQLSecurity() Dim WSHShell, RegKey, rKeyWord, wVer Set WSHShell = CreateObject("WScript.Shell") wVer = Application.Version If wVer 10 Then MsgBox "This macro is for Word 2002 and later!", vbOKOnly, "Wrong Word Version" Exit Sub End If Start: RegKey = "HKEY_CURRENT_USER\Software\Microsoft\Office\" & wVer & "\Word\Options\" On Error Resume Next 'The registry key does not exist rKeyWord = WSHShell.RegRead(RegKey & "SQLSecurityCheck") If rKeyWord = "" Then 'if the added key has no number WSHShell.regwrite RegKey & "SQLSecurityCheck", 1, "REG_DWORD" 'set it at zero GoTo Start: 'and read it again End If If rKeyWord = 1 Then WSHShell.regwrite RegKey & "SQLSecurityCheck", 0, "REG_DWORD" Else WSHShell.regwrite RegKey & "SQLSecurityCheck", 1, "REG_DWORD" End If End Sub This will create and/or toggle the SQL Security Check registry key and will work with any Word version -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#13
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
"SorrentoBob" wrote: In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
#14
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
INCLUDETEXT
The INCLUDETEXTed document should not need to be set up as a MailMerge Main
document with a data source. When it contains MERGEFIELD fields, they take their values from the data source attached to the "master" document. The main benefit to having the included document also attached to the data source is probably that it lets you use the mailmerge "insert field" toolbar stuff to modify your included document. -- Peter Jamieson http://tips.pjmsn.me.uk "SorrentoBob" wrote in message ... In 2003 I could use INCLUDETEXT to call another document or documents into a 'master 'document. That secondary document is linked to the same data file as the master and includes mergefields from that data file.In 2003 the merge works perfectly and pulls in the approopriate seconary document or documents for each record. In 2007 I set up the docs in the same way, BUT when the merge runs it stops at EVERY record to inform me that that the secondary document is linked to the data file and requires me to click OK. Any ideas? -- Thanks, SorrentoBob |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IncludeText Help!! | Microsoft Word Help | |||
IncludeText | Microsoft Word Help | |||
IncludeText | New Users | |||
using INCLUDETEXT? | Microsoft Word Help | |||
IncludeText | Tables |