print labels by group by page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dave - 05 Apr 2007 23:22 GMT

I have a list of about 1500 recipients. Inside this list are groups.

I want to print one big job but have the group create a break in the printed
labels.

If the labels on the page are 30 and there is a group of 25 I want it to
page break after the 25 and start printing the next group on the next full
page and so on.

Has anyone done this or have an idea as to how without having to manipulate
the data source, which is Excel.

Reply to this Message

Doug Robbins - Word MVP - 06 Apr 2007 04:32 GMT

Assuming that there is a "group" field in the data source, it is probably
possible to do that using a modification of the information that you will
find at:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

or

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

or

http://cornell.veplan.net/article.aspx?&a=3815

I would be more inclined to do it by using a macro to insert the necessary
number of blank rows into the data source so that the first member of each
group was a record number that equalled i * nl + 1 where i is an integer and
nl is the number of labels on the sheet.

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

>I have a list of about 1500 recipients. Inside this list are groups.
>
[quoted text clipped - 9 lines]
> manipulate
> the data source, which is Excel.

Reply to this Message

Rate this thread: