Re: SQL, merge fields, and other mysteries

• Previous message: Doug Robbins: "Re: Combining two merged documents"
• In reply to: Geri: "SQL, merge fields, and other mysteries"
• Next in thread: Geri Vaughan: "Re: SQL, merge fields, and other mysteries"
• Reply: Geri Vaughan: "Re: SQL, merge fields, and other mysteries"
• Messages sorted by: [ date ] [ thread ]

Date: Sat, 11 Sep 2004 08:10:06 +0100

Normally when you merge to a new document, that document is not a Mail merge
main document and does not have any fields that would cause this problem to
occur. Although it doesn't really sound like it, I am wondering whether you
are actually opening the mail merge main document, using the preview
facilities to move to a specific record in the data source, then saving that
document under a new name - in which case it will still be a mail merge main
document. IN any case, what you probably need to do is...
 a. in Word 2000 and earlier, click on the mail merge helper button in the
Mailmerge toolbar, which should be visible. Click on the Create button and
select the "Restore to Normal Word Document" option.
 b. in Word 2002 and later, enable the Mailmerge toolbar (Tools|Customize)
if it is not already displayed, click the first button and select the Normal
document option.

-- 
Peter Jamieson
"Geri" <geri_removetheunderscoreandthistext_@wordweaver.com.au> wrote in
message news:03e901c49798$4ce53750$a301280a@phx.gbl...
> 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

• Previous message: Doug Robbins: "Re: Combining two merged documents"
• In reply to: Geri: "SQL, merge fields, and other mysteries"
• Next in thread: Geri Vaughan: "Re: SQL, merge fields, and other mysteries"
• Reply: Geri Vaughan: "Re: SQL, merge fields, and other mysteries"
• Messages sorted by: [ date ] [ thread ]