Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
print labels by group by page
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
print labels by group by page
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/cindy...faq1.htm#DBPic or http://support.microsoft.com/default...b;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. -- 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 "dave" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Labels print 1/2" too low when print a page of 5160 labels! | Microsoft Word Help | |||
How do I print more than one and less than a page of labels | Microsoft Word Help | |||
Can I print only the first page of a group of documents? | Microsoft Word Help | |||
My labels will only print 1 page. Why? TIA | Mailmerge | |||
How do I delete a page of labels from an 8 page label print out? | Microsoft Word Help |