Hi Dileep,
This will be a bit tricky, but it should be possible. Be
prepared to have to spend a bit of time testing and
tweaking...
1. You will need a CATALOG type of mail merge
2. Check out this KB article how to make "lists", because
this technique (checking when a value changes) is the only
way you'll be to force the page break when the city changes,
and display that CITY name at the beginning of that page
WD97: How to Use Mail Merge to Create a List Sorted by
Category [Q181730]
http://support.microsoft.com?kbid=181730
3. Format the CITY header-paragraph and the CONTACT
paragraph with unique styles, so that you can pick this
information up in a TOC
4. You may also want to use StyleRef to put the city name in
the document header (repeats on every page)
I have a database of addresses in Excel format. I wish to
print an address
book with the following features in MS Word using mail
merge.
How do I do it?
= Different page for each city.
=City name as the header on each page.
=A table of contents with two levels - City and contact
name.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
