O
Ol
Hi guys
Not having a lot of luck with finding any help online for this. I've got a
mail merge template, and once run, it is producing the same page 8
times..with exactly the same data.
I can post all the code here if need be (field names displayed below)- but
its over a page long (mailmerge formulae that is)..has anyone got any ideas
why it is repeating the same results?
Many thanks
Olly
-->code
Course Information Number: «CIF_CIFNumber»
Customer: «Booking_CountryName» «Booking_CountrySubDivisionName»
Purchase Order: «Booking_PurchaseOrder» «Booking_PurchaseOrderDate»
IDT(LWC) Serial Number: «Booking_SerialNumber»
Funding Type: «CourseBookingCost_FundingTypeName»
Funding Reference: «CourseBookingCost_FundingRef»
Invoice to be sent to: «CourseBookingCost_FundingTypeCAC»
UIN Number: See table below
COURSE DETAILS
Course Title: «Course_Title»
Catalogue Number: «Course_CatalogueNumber»
Training Establishment: «Course_EstablishmentName»
Course Dates: «CourseBooking_StartDate» - «CourseBooking_EndDate»
TUITION CHARGES
Student Nos «CourseBooking_NumberOfStudents»
Tuition Charge PSC: «Student_SumInvoiceCost»
Total Tuition Charge: «CourseBooking_SumInvoiceCost»
MESSING & ACCOMMODATION CHARGES
This course fee includes all Messing and Accommodation charges.
Invoice Total:«CourseBooking_SumInvoiceCost»
STUDENT DETAILS
«TableStart:Student»
«Student_ServiceNumber» «Student_Rank» «Student_Name»
«TableEnd:Student»
Receipts to be split as follows:
Payable to «Course_AdminCostUIN»
: «Booking_SumAdminCost»
Payable to «Course_AccomCostUIN»
: «Booking_SumAccomCost»
Payable to «Course_MessingCostUIN»
: «Booking_SumMessingCost»
Payable to «Course_MiscCostUIN»
: «Booking_SumMiscCost»
Payable to «Course_TuitionCostUIN»
: «Booking_SumTuitionCost»
Not having a lot of luck with finding any help online for this. I've got a
mail merge template, and once run, it is producing the same page 8
times..with exactly the same data.
I can post all the code here if need be (field names displayed below)- but
its over a page long (mailmerge formulae that is)..has anyone got any ideas
why it is repeating the same results?
Many thanks
Olly
-->code
Course Information Number: «CIF_CIFNumber»
Customer: «Booking_CountryName» «Booking_CountrySubDivisionName»
Purchase Order: «Booking_PurchaseOrder» «Booking_PurchaseOrderDate»
IDT(LWC) Serial Number: «Booking_SerialNumber»
Funding Type: «CourseBookingCost_FundingTypeName»
Funding Reference: «CourseBookingCost_FundingRef»
Invoice to be sent to: «CourseBookingCost_FundingTypeCAC»
UIN Number: See table below
COURSE DETAILS
Course Title: «Course_Title»
Catalogue Number: «Course_CatalogueNumber»
Training Establishment: «Course_EstablishmentName»
Course Dates: «CourseBooking_StartDate» - «CourseBooking_EndDate»
TUITION CHARGES
Student Nos «CourseBooking_NumberOfStudents»
Tuition Charge PSC: «Student_SumInvoiceCost»
Total Tuition Charge: «CourseBooking_SumInvoiceCost»
MESSING & ACCOMMODATION CHARGES
This course fee includes all Messing and Accommodation charges.
Invoice Total:«CourseBooking_SumInvoiceCost»
STUDENT DETAILS
«TableStart:Student»
«Student_ServiceNumber» «Student_Rank» «Student_Name»
«TableEnd:Student»
Receipts to be split as follows:
Payable to «Course_AdminCostUIN»
: «Booking_SumAdminCost»
Payable to «Course_AccomCostUIN»
: «Booking_SumAccomCost»
Payable to «Course_MessingCostUIN»
: «Booking_SumMessingCost»
Payable to «Course_MiscCostUIN»
: «Booking_SumMiscCost»
Payable to «Course_TuitionCostUIN»
: «Booking_SumTuitionCost»