Thread
:
"Next Record If", Mail Merge Issues
View Single Post
#
2
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
Posts: n/a
"Next Record If", Mail Merge Issues
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/cindy...tm#ComplexMerg
as I don't think this is going to work as you envisage.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
wrote:
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
Reply With Quote