 |
 | 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 / February 2006"Next Record If", Mail Merge Issues
I am using an Access database source and using Access 2003 and Word 2003. I'm having a problem with the "Next Record If" feature. I am using this format when I am merging my data: RCA#: _ «RCA»_____________________ (Format: RCAyymmdd-abcnn, where abc=tech initials, nn=number counter) ROOT CAUSE ANALYSIS Date:_«Date» (INV/Pallet#:_«INVPallet» ) Tech Name:_«Tech_Name» (Batch#:_«Batch» ) Equipment/Device:_«Equipment_Type» · Model Number:_«Model_Number» · Serial Number: _«Serial_Number» · (Equip #:_«Equipment_Number» ) User: _«User» Phone: _«User_Phone» · Building:_«Building» · Room/Cube Number:_«RoomCube_Number» PROBLEM TYPE: «Problem_Type» Troubleshooting No. Step «Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» «Next Record If»«Problem_Description» «Steps_to_Complete» RESOLUTION: Unit was: _«Resolution_Fixed__Replaced»_____________________ · Number:_«Resolution» Still pending? _«Resolution_Pending»____________ «Resolution_Pending_Detail» The "Next Record If" is not working correctly. I have a variable number of problem descriptions and steps to complete. It successfully puts those two but when I get down to Resolution and try to merge them I think it tries to pull from a record that is blank. My "Next Record If" condition is that it will go to the next record if the Problem Description is not blank. It will work when I have resolution before I do all the next record if but not if it's after which is where it needs to be. I was thinking maybe there might be a way to go to the first record to get the resolution information or somehow to do multiple merges under one document but I'm not sure about how to go about this. Thank you in advance. Jason Baxter You cannot view the syntax from the way you have displayed your message.Press ALT+F9 and the field should show { NEXTIF { MERGEFIELD Problem_Description } <> "" } However see complex mail merges at http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg as I don't think this is going to work as you envisage.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I am using an Access database source and using Access 2003 and Word > 2003. I'm having a problem with the "Next Record If" feature. [quoted text clipped - 81 lines] > > Jason Baxter Yes it does show this. It won't copy and paste onto here but it shows { NEXTIF { MERGEFIELD Problem_Description } <> "" } In this Word document I have 11 rows that can be merged. I need to find out how to make an append query that will append a variable number of blank rows up to 11 where it needs to be the information from the first row. What I was looking at is to make a query that counts the number of rows and use that number to create the other query to append my blank rows and another one to append the first row's information. I wish there was an easier way to do this but it looks like there no way to get around this. I hope you can help me. Thank you. Given that your data is in an Access database, you should be using an Access Report, not mailmerge. Word does NOT have the ability to merge multiple items for a single condition. See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic Or take a look at the following Knowledge Base Articles http://support.microsoft.com/default.aspx?scid=kb;en-us;302665 http://support.microsoft.com/default.aspx?scid=kb;en-us;294686 But if I were you, I would use an Access Report! 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 > Yes it does show this. It won't copy and paste onto here but it shows > [quoted text clipped - 10 lines] > > Thank you. How would you make a report that has multiple conditions on one page. I got it to put it on multiple pages but that's not what I want. Thank you You use grouping in the report design with the single item plus the text associated with it in the group header, and the multiple items in the detail section of the report and any closing text in connection with the single in the group footer. 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 > How would you make a report that has multiple conditions on one page. > I got it to put it on multiple pages but that's not what I want. > > Thank you Could someone go into more detail on how to put for example if you had this data RCA#: _ «RCA»_____________________ (Format: RCAyymmdd-abcnn, where abc=tech initials, nn=number counter) ROOT CAUSE ANALYSIS Date:_«Date» (INV/Pallet#:_«INVPallet» ) Tech Name:_«Tech_Name» (Batch#:_«Batch» ) Equipment/Device:_«Equipment_Type» · Model Number:_«Model_Number» · Serial Number: _«Serial_Number» · (Equip #:_«Equipment_Number» ) User: _«User» Phone: _«User_Phone» · Building:_«Building» · Room/Cube Number:_«RoomCube_Number» PROBLEM TYPE: «Problem_Type» Troubleshooting No. Step «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» «Problem_Description» «Steps_to_Complete» RESOLUTION: Unit was: _«Resolution_Fixed__Replaced»_____________________ · Number:_«Resolution» Still pending? _«Resolution_Pending»____________ «Resolution_Pending_Detail» There is the Equipment table and Problem table. The Problem table has: Problem Description and Resolution along with the foreign key from Equipment I'm not quite understanding how to use grouping in the design view of reports and how to connect the multiple fields together without getting multiple pages if I have more than one problem. Thank you in advance I figured it out. Thank you for all your previous help Never mind, I figured it out Thank you for all your help in the past. |
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.