Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
---- ---- --- -- -- - -
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
create a list of tables for table of contents CPO Tom G Tables 1 February 11th 09 08:54 PM
Create a list box on a table cell Terry Tables 2 November 13th 06 01:20 AM
How can I use an Excel database to create a callback list in Word? Gary Microsoft Word Help 2 July 31st 06 03:06 PM
How do I create a dropdown list in word which is link to excel? Bad Microsoft Word Help 1 January 25th 06 01:17 PM
how do i create a drop down list box in a word table? Mike Page Layout 1 December 2nd 05 07:19 PM


All times are GMT +1. The time now is 01:16 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"