Saving A Merge Document

[Alice]

I'm trying to set up a merge document using an Access query as the data
source. In the query there is a field named homeqddp. Each time homeqddp
changes I want Word to create a document with the merge information and save
it so the name of the document is the same as the homeqddp field. Is this
possible?
Thanks

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?QWxpY2U=?=,

I'm trying to set up a merge document using an Access query as the data
source. In the query there is a field named homeqddp. Each time homeqddp
changes I want Word to create a document with the merge information and save
it so the name of the document is the same as the homeqddp field. Is this
possible?

No, mail merge doesn't support anything like this. Mail merge exists to create
batches of the same document, with some variable fields. Like labels, or form
letters. You have to set a criteria, and execute the merge.

Closest would probably be to use a Form in Access that reacts when this field is
changed. It could execute code in Access, for example, that would create the
letter (not necessarily using mail merge, which is really overkill for "one off"
letters). An Access newsgroup would be the best place to pursue how to create
the form. You'll find a sample file, WdAcc97.zip, in the Special merges section
of my website's mail merge FAQ that demonstrates how you can pass Access data
into a document created from a Word template, and save it.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Doug Robbins - Word MVP]

Here's a method that I have used that involves creating a separate
catalog type mailmerge maindocument which creates a word document containing
a table in each row of which would be your data from the database that you
want to use as the filename.

You first execute that mailmerge, then save that file and close it. Then
execute the mailmerge that you want to create the separate files from and
with the
result of that on the screen, run a macro containing the following code
and when the File open dialog appears, select the file containing the table
created by the first mailmerge

' Throw Away Macro created by Doug Robbins
'
Dim Source As Document, oblist As Document, DocName As Range, DocumentName
As String
Dim i As Long, doctext As Range, target As Document
Set Source = ActiveDocument
With Dialogs(wdDialogFileOpen)
.Show
End With
Set oblist = ActiveDocument
Counter = 1
For i = 1 To oblist.Tables(1).Rows.Count
Set DocName = oblist.Tables(1).Cell(i, 1).Range
DocName.End = DocName.End - 1

'Change the path in the following command to suit where you want to save
the documents.
DocumentName = "I:\WorkArea\Documentum\" & DocName.Text
Set doctext = Source.Sections(i).Range
doctext.End = doctext.End - 1
Set target = Documents.Add
target.Range.FormattedText = doctext
target.SaveAs FileName:=DocumentName
target.Close
Next i


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP