Reply
 
Thread Tools Display Modes
  #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
---- ---- --- -- -- - -
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Create a list from an excel table

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



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

heh
I was using the wrong document type!

As for the rest:

1, I can't use the add-in because I'm writing a tutorial for Word features
and that is not among them. However I can add a note about it, and its owner,
assuming I have his permission.

2. When I first read (and followed) the instructions under KB294686 article,
was only applicable if the source document was a text file and not an Excel
table. So I didn't test it again to see if they have corrected it.

3. I've downloaded your zip archive and I give it a try right now

Thanks for all info


"Graham Mayor" wrote:

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



.

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Create a list from an excel table

You my permission to make reference to the add-in. Add-ins are however
"Word features".

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"geotso" wrote in message
...
heh
I was using the wrong document type!

As for the rest:

1, I can't use the add-in because I'm writing a tutorial for Word features
and that is not among them. However I can add a note about it, and its
owner,
assuming I have his permission.

2. When I first read (and followed) the instructions under KB294686
article,
was only applicable if the source document was a text file and not an
Excel
table. So I didn't test it again to see if they have corrected it.

3. I've downloaded your zip archive and I give it a try right now

Thanks for all info


"Graham Mayor" wrote:

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



.

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

"Doug Robbins - Word MVP" wrote:

You my permission to make reference to the add-in. Add-ins are however
"Word features".

Thank you very much Doug...

Add-ins are word features indeed. My mistake. I said "I can't use the add-in
because I'm writing a tutorial for Word features and that is not among them"
and I meant "...is not among them with Word's default installation"
Reply
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 12:24 PM.

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

About Us

"It's about Microsoft Word"