I am trying to use the Mail Merge function with Word to create letters. The
data source is an Excel file that looks like below: What I need to know how
to do is have the document merge the rows from excel until there is a change
in Custid. Once there is a change in the Custid, have it give a grand total
for the Total2005 and Total2004, then do a page break to start the next
document. I have it merging from excel, but its just merging one row at a
time, then does a page break. Any ideas?


Custid Name Status Dept DeptDesc Total2005 Total2004
000100 Test & ASSOCIATES INSURANCE 010 901 Personal Auto
$23,742.00 $36,267.00
000100 Test &ASSOCIATES INSURANCE AGENCY 010 903 Personal Property
$3,257.00 $5,395.00
000100 Test & ASSOCIATES INSURANCE AGENCY 010 922 Garage $8,978.00
$7,120.00
000100 Test & ASSOCIATES INSURANCE AGENCY 010 947 Property and
Casualty $26,744.00 $36,617.00
000102 Thomas
INSURANCE 010 903 Personal Property $3,254.00 $3,723.00
000102 Thomas
INSURANCE 010 922 Garage $0.00 $335.00
000102 Thomas
INSURANCE 010 933 MARINE AND SPORTS $204.25 $259.00
000102 Thomas
INSURANCE 010 947 Property and Casualty $22,908.00 $5,687.00
000103 Barney INC. 010 903 Personal Property $2,613.00 $2,042.00