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  

Issue with {NextRecord} field when there are not multiple records in source file



 
 
Thread Tools Display Modes
  #1  
Old August 17th, 2004, 08:11 PM
Gilley
external usenet poster
 
Posts: n/a
Default Issue with {NextRecord} field when there are not multiple records in source file

Hi,

I am using Word 2002 on an XP box and for the life of me,=20
I can't figure out what I am doing wrong. I will try to=20
explain it to the best of my ability.=20

In my main document, I have to allow for multiple records.=20
However, there may be only one record in the source data=20
file. This causes a problem with any merge fields listed=20
below where the multiple records are. If there are less=20
records in the data file than lines (when I use next=20
record) on the document, any merge field below this=20
section doesn't display the results.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=

Qty Model # Description Serial #
=ABITEMNO=BB =ABITEMDESC=BB=20
=ABNext Record=BB=ABITEMNO=BB =ABNext Record=BB=ABITEMDESC=BB=20
=ABNext Record=BB=ABITEMNO=BB =ABNext Record=BB=ABITEMDESC=BB=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=


I have worked around this issue on most of the reports by=20
moving the product lines to the end of the page. However,=20
on two of the reports this isn't possible.

Warmest regards,

Gilley

  #2  
Old August 18th, 2004, 03:11 AM
bobul
external usenet poster
 
Posts: n/a
Default

Gilley,

Did you get an answer for your question? I am having the=20
same problem and need help.

Thanks,
Lynne
-----Original Message-----
Hi,

I am using Word 2002 on an XP box and for the life of me,=20
I can't figure out what I am doing wrong. I will try to=20
explain it to the best of my ability.=20

In my main document, I have to allow for multiple=20

records.=20
However, there may be only one record in the source data=20
file. This causes a problem with any merge fields listed=20
below where the multiple records are. If there are less=20
records in the data file than lines (when I use next=20
record) on the document, any merge field below this=20
section doesn't display the results.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= 3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
Qty Model # Description Serial #
=ABITEMNO=BB =ABITEMDESC=BB=20
=ABNext Record=BB=ABITEMNO=BB =ABNext Record=BB=ABITEMDESC=BB=20
=ABNext Record=BB=ABITEMNO=BB =ABNext Record=BB=ABITEMDESC=BB=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= 3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D

I have worked around this issue on most of the reports by=20
moving the product lines to the end of the page. However,=20
on two of the reports this isn't possible.

Warmest regards,

Gilley

.

  #3  
Old August 18th, 2004, 07:55 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default

As you have gathered, mail merge doesn't work like that. There are two
approaches, depending on what you are trying to achieve. The first would be
to do a catalog/directory merge to a new document then add the supplementary
information. The other would be to create a complex merge - see the section
on complex merges on Cindy's web site at
http://homepage.swissonline.ch/cindymeister

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Gilley wrote:
Hi,

I am using Word 2002 on an XP box and for the life of me,
I can't figure out what I am doing wrong. I will try to
explain it to the best of my ability.

In my main document, I have to allow for multiple records.
However, there may be only one record in the source data
file. This causes a problem with any merge fields listed
below where the multiple records are. If there are less
records in the data file than lines (when I use next
record) on the document, any merge field below this
section doesn't display the results.

==================================================
Qty Model # Description Serial #
«ITEMNO» «ITEMDESC»
«Next Record»«ITEMNO» «Next Record»«ITEMDESC»
«Next Record»«ITEMNO» «Next Record»«ITEMDESC»
==================================================

I have worked around this issue on most of the reports by
moving the product lines to the end of the page. However,
on two of the reports this isn't possible.

Warmest regards,

Gilley



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
URGENT: Mailing rule problems of filing in outlook express and hard copy file systems in real case Teres Outlook Express 7 August 14th, 2004 01:55 AM
Application must be installed to run Error Keith Setup, Installing & Configuration 1 June 29th, 2004 03:02 AM
NUMBERING the pages Bob New Users 7 June 14th, 2004 12:20 AM
How to Customize File As field Srini Iyer Contacts 1 May 27th, 2004 11:56 PM
Supress blank lines in DOCPROPERTY field Mary Formatting Long Documents 10 May 25th, 2004 07:27 PM


All times are GMT +1. The time now is 12:30 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.