A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Create a list from an excel table



 
 
Thread Tools Display Modes
  #1  
Old March 27th, 2010, 03:14 PM posted to microsoft.public.word.mailmerge.fields
geotso[_2_]
external usenet poster
 
Posts: 56
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  
Old March 27th, 2010, 03:45 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
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  
Old March 27th, 2010, 05:55 PM posted to microsoft.public.word.mailmerge.fields
geotso[_2_]
external usenet poster
 
Posts: 56
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  
Old March 27th, 2010, 10:13 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
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  
Old March 28th, 2010, 04:58 PM posted to microsoft.public.word.mailmerge.fields
geotso[_2_]
external usenet poster
 
Posts: 56
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"
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.