[Doug Robbins - Word MVP]

After you setup your label type mail merge main document with a data source
and the mergefields, if you run the following macro, it will ask you how
many labels have already been used on the sheet and then insert the
necessary number of blank rows into the datasource so that the first record
containing data is printed on the first unused label.

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

"sunbeam" wrote in message
...
Is it possible to designate a starting point for the printing of labels?
Each set I print starts at Row 1, Column 1 and I would like to be able to
use
any unused labels for a future printing.