Set the merge document type to Directory/Catalog -
MVP Doug Robbins has developed an add-in to effect this type of merge. See
http://www.gmayor.com/ManyToOne.htm for the download link and an explanation
of its use.
Fellow MVP 'macropod' has prepared a tutorial employing a different method
based on the Microsoft support link (below), with working field codes and a
sample Excel data source which you can also download from my website
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
"geotso" wrote in message
...
I think I use exactly the step by step Mail merge wizard, in order to make
a
list from an Excel table, using the following fields:
{QUOTE {IF{MERGESEQ}="1" {SET Place ""}} "{IF{MERGEFIELD City} {Place}
"{IF{MERGESEQ}= "1" "" "
"}{MERGEFIELD City}{SET Place {MERGEFIELD City}}
"}{MERGEFIELD Company} {MERGEFIELD Debt}
"}
From the above I hope to get a list like this:
City 1
Company1 its debt
Company2 its debt
City 2
Company3 its debt
City 3
Company4 its debt
Company5 its debt
Company6 its debt
... etc ...
However, at the end I get the company and its debt each in a different
page
like:
City 1
Company1 its debt page break
City 1
Company2 its debt page break
... etc ...
What I'm doing wrong?
--
geotso
---- ---- --- -- -- - -
Please, remove hyphens to contact me
---- ---- --- -- -- - -