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 / August 2004

Tip: Looking for answers? Try searching our database.

Disappearing results

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gilley - 12 Aug 2004 15:29 GMT
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 :-)
 
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.