Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I set up rows and columns on used label sheet?
-- tech-ill |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I set up rows and columns on used label sheet?
Maybe this will do what you want (You did not give much to go on)
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 "tech-ill" wrote in message ... -- tech-ill |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I set up rows and columns on used label sheet?
Do you mean "how do I print labels in the unused part of a used sheet of
labels" ? If so, are you printing multiple copies of the same label, or are you mailmerging to labels? Are you only ever printing labels on a single sheet at a time? Peter Jamieson "tech-ill" wrote in message ... -- tech-ill |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge using columns instead of rows | Mailmerge | |||
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? | Tables | |||
label page with 3 columns and 3 rows? | New Users | |||
convert columns into rows | Tables | |||
can you put rows instead of cloumns on the sheet in microsoft wo. | Page Layout |