Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
In mail merge can I select which label to start with printing
I have sheets of address lables that have only a few labels used (missing)
and want be able to use up the rest of the sheet. So can i select which label to start printing from or does it always have to to start with the first label on the sheet? -- Clerk |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
In mail merge can I select which label to start with printing
You can with the following macro
Macro to set the first label on a part sheet of labels for a label type mailmerge. Dim MMMDoc As Document Dim dsource As Document Dim dtable As Table Dim i As Long, j As Long Set MMMDoc = ActiveDocument With MMMDoc.MailMerge If .MainDocumentType = wdMailingLabels Then If .State = wdMainAndDataSource Then Set dsource = Documents.Open(.DataSource.Name) Set dtable = dsource.Tables(1) i = InputBox("Enter the number of labels that have already been used on the sheet.", "Set Starting Label") If IsNumeric(i) Then With dtable For j = 1 To i .Rows.Add BeforeRow:=.Rows(2) Next j End With End If .Destination = wdSendToNewDocument .Execute End If End If End With dsource.Close wdDoNotSaveChanges -- 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, originally posted via msnews.microsoft.com "PIB Clerk" wrote in message ... I have sheets of address lables that have only a few labels used (missing) and want be able to use up the rest of the sheet. So can i select which label to start printing from or does it always have to to start with the first label on the sheet? -- Clerk |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Label printing from excel mail merge | Mailmerge | |||
printing a label mail merge | Mailmerge | |||
in label merge, can I start at a specific label spot? | Mailmerge | |||
Printing select number of labels from a mail merge result | Mailmerge | |||
Printing multiple copies of each label using mail merge | Mailmerge |