J
jasonrbaxter
I am using Access 2003 for this problem
What I am trying to do is Create a mail merge with Access as my data
source. I figured out how to include multiple records but the form I
am using in Word need the source to be 11 records long.
For instance:
Problem Description Steps to Complete
_________________ _______________
_________________ _______________
_________________ _______________
There are 11 lines where the document goes.
Here is the document I am trying to merge with the access database.
RCA#: _ «RCA»_____________________
Tech Team (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
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
RESOLUTION:
Unit was: _«Resolution_Fixed__Replaced»_____________________
· Number:_«Resolution_Number»
· S/N: _
Still pending? _«Resolution_Pending»____________
«Resolution_Pending_Detail»
I use "Next Record If" because I thought Word would go to the next
record if there was only something in it.
Right now it queries the database and makes a table on that query. The
information is then taken from the newly made table and is merged with
the existing Word document. The problem is when Word uses "Next Record
If" it goes one record too far and the resolution section does not get
filled in.
Therefore I need to know if there is a way to append blank records to
the database until record 11 which needs to include the same data as
the 1st record.
Thank you in advance
What I am trying to do is Create a mail merge with Access as my data
source. I figured out how to include multiple records but the form I
am using in Word need the source to be 11 records long.
For instance:
Problem Description Steps to Complete
_________________ _______________
_________________ _______________
_________________ _______________
There are 11 lines where the document goes.
Here is the document I am trying to merge with the access database.
RCA#: _ «RCA»_____________________
Tech Team (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
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
«Merge Record #»«Problem_Description»
«Steps_to_Complete»«Next Record If»
RESOLUTION:
Unit was: _«Resolution_Fixed__Replaced»_____________________
· Number:_«Resolution_Number»
· S/N: _
Still pending? _«Resolution_Pending»____________
«Resolution_Pending_Detail»
I use "Next Record If" because I thought Word would go to the next
record if there was only something in it.
Right now it queries the database and makes a table on that query. The
information is then taken from the newly made table and is merged with
the existing Word document. The problem is when Word uses "Next Record
If" it goes one record too far and the resolution section does not get
filled in.
Therefore I need to know if there is a way to append blank records to
the database until record 11 which needs to include the same data as
the 1st record.
Thank you in advance