View Single Post
  #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
---- ---- --- -- -- - -



.