Different subject, but there's some information on setting up a catalog or
directory merge in
the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
--
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
"krstnl" wrote in message
...
Thank you both! Before you replied though I made a good old college try
by
copying and pasting the splitter macro script into the macros I already
had
(via macro edit). Then I ran it... ....and later found the documents
("Letter 1" etc) in a higher folder. Kind of successful, but the margins
and
tabs were wrong (those of the Normal template?). ? I also saw in your
Throw Away macro that you've got a method for naming the files with a
field,
but you base it on first doing a "catalog merge" to get a Word table -- I
don't know how to do that, can I use the Access table?
"Doug Robbins" wrote:
You run the splitter macro in Word when the "roll of toilet paper" is the
active document.
See the article "What do I do with macros sent to me by other newsgroup
readers
to help me out?" at:
http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm
--
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
"krstnl" wrote in message
...
I'm very new, please forgive. My data source is an Access table. How
do
I
use these scripts? I have a source document, an Access table data
source,
and a merged target document that has 15 reports strung together like a
roll
of toilet paper. I'd like 15 separate documents named based on one of
the
fields. Thank you.
"Doug Robbins" wrote:
For saving individual mergedocuments, you can use either of the
following:
Sub splitter()
' splitter Macro
' Macro created by Doug Robbins to save each letter created by a
mailmerge
as a separate file.
Dim i As Long, Source as Document, Target as Document, Letter as Range
Set Source = ActiveDocument
For i = 1 to Source.Sections.Count
Set Letter = Source.Sections(i).Range
Letter.End=Letter.End-1
Set Target = Documents.Add
Target.Range=Letter
Target.SaveAs FileName:="Letter" & i
Target.Close
Next i
End Sub
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
--
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
"KMMartin" wrote in message
...
I have a single document that I need to merge customer numbers into
and
then
save as separate documents. There are over 200 so I don't want to
do
this
manually. I can perform the merge - that's easy. It's getting the
merge
to
save the results as multiple files rather than a single file of
multiple
pages that I'm having problems with. Please help!