Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
word+excel mail merge omits 1st numeric record | Mailmerge | |||
mail merge screws up one record, others okay | Mailmerge | |||
sort mail merge by merge record number | Mailmerge | |||
Mail Merge - Next Record If Statement | Mailmerge | |||
mail merge with attachments | Mailmerge |