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

forgot something - The Custid and Names need to only print once on the
letter. Only the Dept Desc and Totals are the lines that would continue
merging until the Custid field changed.

"Scott Morgan" wrote in message
...
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

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 Articles

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


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

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

"Scott Morgan" wrote in message
...
forgot something - The Custid and Names need to only print once on the
letter. Only the Dept Desc and Totals are the lines that would continue
merging until the Custid field changed.

"Scott Morgan" wrote in message
...
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