View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
geotso[_2_] geotso[_2_] is offline
external usenet poster
 
Posts: 47
Default Create a list from an excel table

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