Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2005

Tip: Looking for answers? Try searching our database.

Word 2000

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hansnanc - 12 Jul 2005 14:30 GMT
I created a mail merge document.  To create a telephone directory.  When I
merge the information it is dropping every 5th entry. There are 4 entries per
page on the template (pf).

Any ideas??
Peter Jamieson - 12 Jul 2005 15:49 GMT
If you have 4 { NEXT } fields (<<Next record>> fields) in your mail merge
main document, you have one too many - if you have one before the first
record or after the last record, delete it.

Peter Jamieosn
>I created a mail merge document.  To create a telephone directory.  When I
> merge the information it is dropping every 5th entry. There are 4 entries
> per
> page on the template (pf).
>
> Any ideas??
Hansnanc - 13 Jul 2005 11:23 GMT
Thank you, Thank you, Thank you!  I have been waiting for 3 days for someone
at out HelpDesk to "HELP".  I haven't used a mail merge in quite a while.

Thanks again.

> If you have 4 { NEXT } fields (<<Next record>> fields) in your mail merge
> main document, you have one too many - if you have one before the first
[quoted text clipped - 7 lines]
> >
> > Any ideas??
Gert Raes - 13 Jul 2005 12:31 GMT
Peter,

an additional question to this subject :

sometimes I have to create a mailmerge document, not knowing how many
entries there will be.
How can I create a perfect document without having to many blank lines (if
the amount of entries is smaller than the lines I've created in my document) ?

Gert

"Peter Jamieson" schreef:

> If you have 4 { NEXT } fields (<<Next record>> fields) in your mail merge
> main document, you have one too many - if you have one before the first
[quoted text clipped - 7 lines]
> >
> > Any ideas??
Peter Jamieson - 13 Jul 2005 12:51 GMT
Typically when people try to do this, they are attempting to do "multiple
items per condition". In that case, Word itsn't very good at it, but have a
look at Cindy Meister's page at

http://homepage.swissonline.ch/cindymeister/

Look for Mail Merge FAQ, Special Merges, Multiple items per condition.

It's worth pointing out that in each Office Service Pack, Microsoft tries to
tighten security and that often creates problems whenever you try to include
information using fields.

Peter Jamieson
> Peter,
>
[quoted text clipped - 23 lines]
>> >
>> > Any ideas??
Gert Raes - 13 Jul 2005 13:13 GMT
Maybe I missed it at Cindy's site but :

It's actually a quite simple document
{MERGEFIELD M_1}
   {MERGEFIELD M_2} {NEXT}
This goes on for pages and at the end there is a line without a {NEXT}

But for example: if my document contains 1000 of these lines and my
datasource has only 250 entries, I end up with a lot of blank lines....

"Peter Jamieson" schreef:

> Typically when people try to do this, they are attempting to do "multiple
> items per condition". In that case, Word itsn't very good at it, but have a
[quoted text clipped - 36 lines]
> >> >
> >> > Any ideas??
Peter Jamieson - 13 Jul 2005 14:30 GMT
If it's that simple, change the type of Merge to Catalog, and insert just
one set of fields and no { NEXT }.

Peter Jamieson
> Maybe I missed it at Cindy's site but :
>
[quoted text clipped - 55 lines]
>> >> >
>> >> > Any ideas??
Cindy M  -WordMVP- - 13 Jul 2005 14:36 GMT
Hi =?Utf-8?B?R2VydCBSYWVz?=,

> Maybe I missed it at Cindy's site but :
>  
[quoted text clipped - 5 lines]
> But for example: if my document contains 1000 of these lines and my
> datasource has only 250 entries, I end up with a lot of blank lines....

None of the techniques that give a "good" result use the NEXT field. One
uses a DATABASE field to generate at table for the results. The other a
complex combination of SET and IF fields. In both cases, there's a link
to documentation that explains the approach in detail. The DATABASE field
approach is simpler to set up, but the other one gives you more
flexibility in how the result will look.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.