Hi,
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.
When I am viewing my document so that I can see the merge
fields (not the field codes), the result for New Order #:
displays (See Example 1).
However, when I view the results (either through a merge
to new document or view in the merge document), the result
for New Order #: disappears (See Example 2).
Example 1: (normal mailmerge view)
=================================================Qty Model # Description Serial #
«ITEMNO» «ITEMDESC»
«Next Record»«ITEMNO» «Next Record»«ITEMDESC»
«Next Record»«ITEMNO» «Next Record»«ITEMDESC»
Replacement Order: New Order #: 241778
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Example 2: (with merge results displayed)
==================================================
Qty Model # Description Serial #
-813S TWIN/FUTON METAL
BUNK BED
Replacement Order: New Order #:
Qty Model # Description Value
I am using an IF statement to achieve the results I need
{if {mergefield itemno} <> " " {mergefield orderno}}.
My question is ...
Why wont the results display when viewing the merge
results?
One more bit of information ...
This is only a problem when I have multiple merge fields
with {next record} in the document above where the orderno
is to display and don't have that many records in the data
source. i.e. 3 lines with {next} and only 1 line of data
in the source file.
THANKS for any help you can give,
Warmest regards,
Gilley
Cindy M -WordMVP- - 21 Aug 2004 12:12 GMT
Hi Gilley,
Which version of Word, and what's the data source (Excel,
Access, other)?
Is the data that's disappearing purely numerical, or mixed
numbers and text *in the same column*?
> 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
[quoted text clipped - 43 lines]
> source. i.e. 3 lines with {next} and only 1 line of data
> in the source file.
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 :-)