[Michael]

Hey Guys.

I need some help. I am creating these letters using mail merge from an excel
spreadsheet. The problem is that I need to create 100 2-page letters and the
output is one huge word document.

How do I perform this mail merge and automatically break it apart into
separate files? It is a nightmare to do manually. (And I worried about
updates to the template.)

Also is there anyway to automatically rename the new files as well using the
name field from the Merge. "Letter for NAME.doc "

Thanks for your help on this!

Regards,

-Michael

[Doug Robbins - Word MVP]

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.


--
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

"Michael" wrote in message
...
Hey Guys.

I need some help. I am creating these letters using mail merge from an
excel
spreadsheet. The problem is that I need to create 100 2-page letters and
the
output is one huge word document.

How do I perform this mail merge and automatically break it apart into
separate files? It is a nightmare to do manually. (And I worried about
updates to the template.)

Also is there anyway to automatically rename the new files as well using
the
name field from the Merge. "Letter for NAME.doc "

Thanks for your help on this!

Regards,

-Michael