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»

It appears that you are trying to perform a "multiple items per condition
(=key field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303


--
Hope 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

"Ol" wrote in message
news
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»