View Single Post
  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Teeroi
 
Posts: n/a
Default MS Word - Creat a new document for each record

Thanks again Doug - tons of very helpful information in that last post.
And I may have been a bit cinfusing in my description of the mail
merge process. Inside of each table is up to 10 different record
"types", each of which requires a different mail merge main document.
Ideally, I need Word to open the table, separate the records by type,
then merge each record to its corresponding mail merge document, and
save eash as its own individual document. As an example:

A B C
Bed Tom Wolfe
Chair Sue Jones
Wall Jim Smith
Wall John Henry


Each record where A=Bed would merge with bed.doc and save as "B C.doc"
Each record where A=Chair would merge with chair.doc and save as "B
C.doc"
Each record where A=Wall would merge with wall.doc and save as "B
C.doc"

I've worked out the datasource connection, the mail merge itself, and
the autosave and file naming process. The part I'm stuck on is
choosing the mail merge main document based on record type. I hope
this makes things a bit clearer.