How to page break with mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Morgan - 23 Jan 2006 18:08 GMT

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

Reply to this Message

Scott Morgan - 23 Jan 2006 18:12 GMT

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.

> 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
[quoted text clipped - 22 lines]
> 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

Reply to this Message

Doug Robbins - Word MVP - 23 Jan 2006 20:59 GMT

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 Articles

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

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

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

> 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
[quoted text clipped - 33 lines]
>> 000103 Barney INC. 010 903 Personal Property $2,613.00
>> $2,042.00

Reply to this Message