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