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 / November 2003

Tip: Looking for answers? Try searching our database.

SubDocuments - In a Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jado - 10 Nov 2003 16:22 GMT
Hi

i want to run a mail merge process that will consist of 2 parts out of a
possible 3.

Part 1 = Master Doc
Part 2 = SubDoc 1
Part 3 = SubDoc 2

i want to produce either Part 1 & Part 2
or
Part 1 & Part 3

all 3 parts us merge fields residing in the same Access 97 table
and i want to inclued with Part 1 ..either P2 or P3 based on a value in a
field..

say there are 5 records to be merged....

how do i get word to look at the value in a field and include the correct
SubDocument for that record??

i haven't used SubDoc's in any way before..so a complete proceadure would be
a great help!

Thanks All
(any questions...please ask)
Jado
Peter Jamieson - 10 Nov 2003 18:00 GMT
You can use INCLUDETEXT fields to include stuff conditionally. But I
wouldn't even go near normal Word "Master documents and subdocuments" to do
this - just use regular documents and ensure that any styles you use are set
up the same way in each document.

Then either use nested IF feilds with INCLUDETEXT, e.g.

Part 1 is the fist part of your mail merge main document. Then have
something like

{ IF { MERGEFIELD SecondPart } = 2
"{ INCLUDETEXT "c:\\pathname\\part2.doc" }"
"{ INCLUDETEXT "c:\\pathname\\part3.doc" }" }

Or, if you can relate the database field to the document name in a useful
way, you might use something like

{ INCLUDETEXT "c:\\pathname\\part{ MERGEFIELD SecondPart }.doc" }

All the {} need to be the special field code braces you can enter using
ctrl0F9

--
Peter Jamieson
MS Word MVP

> Hi
>
[quoted text clipped - 24 lines]
> (any questions...please ask)
> Jado
Jado - 13 Nov 2003 11:57 GMT
Thanks Peter...

but before i start...

the sub parts of the main document also contain MergeFields which are held
in the same datasource! (not just static text)

so what i am trying to build is a dynamic MailMerge template...

will this work as you explained..?

Thanks

Jado

> You can use INCLUDETEXT fields to include stuff conditionally. But I
> wouldn't even go near normal Word "Master documents and subdocuments" to do
[quoted text clipped - 51 lines]
> > (any questions...please ask)
> > Jado
Peter Jamieson - 13 Nov 2003 13:52 GMT
> will this work as you explained..?

The fields in INCLUDETEXTed documents should work - in most situations at
any rate - as if they were part of the main document.

The INCLUDETEXTed documents do not need to be attached to the Mail Merge
Data Source when you run the merge (I don't think it really matters if they
/are/ attached, but I would probably attach each subdocument to the data
source to make it easy to insert the merge fields, then restore each
subdocuments to a normal, non-mail merge document).

--
Peter Jamieson
MS Word MVP

> Thanks Peter...
>
[quoted text clipped - 71 lines]
> > > (any questions...please ask)
> > > Jado
 
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.