Repeating pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ol - 17 Feb 2006 15:42 GMT

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»

Reply to this Message

Doug Robbins - Word MVP - 17 Feb 2006 21:03 GMT

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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Signature

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

> Hi guys
>
[quoted text clipped - 72 lines]
> Payable to «Course_TuitionCostUIN»
> : «Booking_SumTuitionCost»

Reply to this Message