Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

Multiple merge Documents

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul - 24 Aug 2004 15:44 GMT
Can anyone help me.

I have multiple merge documents that all use the same data source (TAB
delimited txt file)

I have a "Merge Macro.dot" document that I call that runs a macro to
do the mail merge.

It reads a list of the documents that I want to merge

e.g

'Read the list of documents to be merged
Open ("C:\Mydoclist.txt") For Input As #1
   Do While Not EOF(1)
       Input #1, FileToPrn
       'Insert the actual file
       Selection.Range.Subdocuments.AddFromFile Name:="C:\"&
FileToPrn, ReadOnly:=True
   Loop
Close #1

And then does the mail merge.

ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:="C:\emergdat.txt"
   With ActiveDocument.MailMerge
       .Destination = wdSendToNewDocument
       .MailAsAttachment = False
       .MailAddressFieldName = ""
       .MailSubject = ""
       .SuppressBlankLines = True
       With .DataSource
           .FirstRecord = wdDefaultFirstRecord
           .LastRecord = wdDefaultLastRecord
       End With
       .Execute Pause:=True
   End With

The problem is that is joins all the documents together to make one
long document. I need it wo be separate documents. I.e There will be
multiple windows open in Word.

I don't really know the Word VBA but I can't find anything that would
instruct word to create a new document each time.

Any help would be appreciated

Thanks in Advance
Cindy M  -WordMVP- - 24 Aug 2004 16:41 GMT
Hi Paul,

I'm not clear on what you mean by the "multiple documents" that should
result. Do you mean a separate document for each record you're merging?
Or separate documents containing all the records for each of the "main"
documents you're pulling in using the SubDocument feature?

For the former (pulling apart the resulting records of a merge) there
are various approaches (my website and word.mvps.org). But most of them
base on the fact that a section break is inserted between each new
record. However, since you're using the SubDocument feature, your main
document is already chock full of section breaks...

Assuming that only the mail merge is inserting New Page section breaks,
you could try modifying either of these approaches to test for that type
of section break.

Or, if this is Word 2002/2003 you might want to consider using mail
merge events to change how the result is being processed.

> I have multiple merge documents that all use the same data source (TAB
> delimited txt file)
[quoted text clipped - 40 lines]
> I don't really know the Word VBA but I can't find anything that would
> instruct word to create a new document each time.

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 :-)
Paul - 25 Aug 2004 07:32 GMT
> Hi Paul,
>
[quoted text clipped - 15 lines]
> Or, if this is Word 2002/2003 you might want to consider using mail
> merge events to change how the result is being processed.

Basically I have documents A,B,C...... with merge fields in them. They
all use the same data source because they use the same records but in
different areas of the documents.

So now the client wants to merge documents A and C but they want them
to be separate documents and not one document with these 2 documents
"inserted".

Is using the subdocument command the wrong command to use? Is there
not a way to say "Start each subdocument as a new document"
Cindy M  -WordMVP- - 25 Aug 2004 10:33 GMT
Hi Paul,

> Is using the subdocument command the wrong command to use? Is there
> not a way to say "Start each subdocument as a new document"

No, there's not. The Master Document feature was actually designed to bring
things together for printing, not pull them apart :-) Also, a MasterDoc isn't
reknowned for being the most stable construct...

The object model does have a way to open each subdocument in a master
document, then save it as a separate file. You'll find this in the example on
my website for "pulling apart" a mail merge document (separate file for each
record). You can test how well that works on a document resulting from a
mailmerge. I can't see off-hand any reason it would not work, but I've never
tried it, either, so have no idea what effect mail merge might have on the
master document. I do suggest, however, that you choose a CATALOG type merge
to avoid getting any stray section breaks.

> > I'm not clear on what you mean by the "multiple documents" that should
> > result. Do you mean a separate document for each record you're merging?
[quoted text clipped - 24 lines]
> Is using the subdocument command the wrong command to use? Is there
> not a way to say "Start each subdocument as a new document"

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 :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.