 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / September 2005Supressing varying number of rows for each recipient
I am using Access as my data source. The project is a debt collection letter merge. Each recipent has a different number of items due. The relevant part of the record layout is as follows: [Desc_1]; [Amt_1] [Desc_2]; [Amt_2]....[Desc_n]; [Amt_n] The Description field is always NOT NULL; however, the Amount field may be null. If the Amount field is null, how do I supress it and the corrresponding Description? Thanks,  SignatureAlbert Chen Use an If...then...Else field construction to check the amount fields. SignatureHope 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 >I am using Access as my data source. > The project is a debt collection letter merge. [quoted text clipped - 7 lines] > > Thanks, Hi Doug: Thanks for the reply; however, how does If Then Else apply to merge fields? I have only seen it used to insert messages as Word Fields. Please post a brief example of your solution. Thanks very much. SignatureAlbert Chen > Use an If...then...Else field construction to check the amount fields. > [quoted text clipped - 9 lines] > > > > Thanks, {IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1} "}etc Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi Doug: Thanks for the reply; however, how does If Then Else apply > to merge fields? I have only seen it used to insert messages as Word [quoted text clipped - 24 lines] >>> -- >>> Albert Chen Thank you. SignatureAlbert Chen > {IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1} > "}etc [quoted text clipped - 27 lines] > >>> -- > >>> Albert Chen I must be missing something. The following is displayed in the body of my letter: {IF 10.00 < > "" Late Payment Penalty 10.00 } {IF < > "" Interest Charge } So the test is not being performed because it is just merging the Amount field twice. Please help me resolve this. Thanks again. SignatureAlbert Chen > {IF {Mergefield Amt_1] <> "" "{Mergefield Desc_1} {Mergefield Amt_1} > "}etc [quoted text clipped - 27 lines] > >>> -- > >>> Albert Chen Did you insert the field boundaries with CTRL+F9? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I must be missing something. > The following is displayed in the body of my letter: [quoted text clipped - 45 lines] >>>>> -- >>>>> Albert Chen No. I will try it that way. Thanks. SignatureAlbert Chen > Did you insert the field boundaries with CTRL+F9? > [quoted text clipped - 47 lines] > >>>>> -- > >>>>> Albert Chen
|
Reply to this Message |
 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.