Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default

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
"Alice" wrote in message
...
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


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Mail Merge for Creating a Document of Biographies... Sam Clarke Microsoft Word Help 1 January 4th 05 04:28 PM
MS WORD - Document open with prompt to merge changes back to a old biswajit_c_in Microsoft Word Help 1 December 21st 04 11:16 PM
How do I merge an excel document Pat McGlamery Tables 1 December 10th 04 03:00 AM
Merge data into one document from several tables in Access. Professor Wise Mailmerge 1 December 2nd 04 10:40 PM
How do I mail merge when only merge document is shown in tools? DaveAS Microsoft Word Help 2 December 1st 04 03:45 PM


All times are GMT +1. The time now is 06:14 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"