SQL, merge fields and other mysteries

[Geri]

[Also posted to the Mail Merge and Fields newsgroup]

Setting the scene...

I have inherited a Filemaker database (Recruitment
Agency). Part of its job is to export (Candidate) data to
a .MER format (called 'Candidate.mer')

A .DOT CV template in Word was created ages ago (by a
previous employee, not trackable) that is nicely
formatted, and holds all the relevant fieldnames that
match the .MER file fields. On opening this .dot
template, a dialogue box is displayed: "OPening this
docuement will run the following SQL command: Select *
from C:\Desktop\Candidate.mer". On selecting 'Yes', it
goes ahead and inserts the related merge field data from
my Filemaker exported file Candidate.mer, into a new
unsaved document.

That's all OK. But now I want to save this document in
plain Word format. So I removed the fields, then save the
file and close it. But no matter what I do, on re-opening
the document (now saved with the name of the Candidate eg
Alvarez.doc etc) it keeps displaying the dialogue box on
opening that asks if I want to run the SQL command. I am
not an SQL expert by any stretch and am stumped.

Here's what I have tried.... Selecting all the text, then
removing fields (CTRL + SHIFT + F9) (that does work, but
doesn't take away the dialogue box on opening). So while
I have removed the fields, there must be some SQL command
embedded in the document that needs to be de-activated in
the saved document. But where?

TIA, Geri

 

[Doug Robbins]

I believe that it has been answered in the other newsgroup.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP