Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 ---- ---- --- -- -- - - |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a list of tables for table of contents | Tables | |||
Create a list box on a table cell | Tables | |||
How can I use an Excel database to create a callback list in Word? | Microsoft Word Help | |||
How do I create a dropdown list in word which is link to excel? | Microsoft Word Help | |||
how do i create a drop down list box in a word table? | Page Layout |