Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Location
    Albany, New York, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Label Format (Word 2000)

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> We have a label document that consists of a mail merge, therefore there are multiple names and addresses on each label sheet. We just want to change the label format from one type of avery label to another. When we do, the problem is we only have the option to print the same name and address on a sheet of labels, or print one label.

    How can I just change the page layout of this document from the current label layout to a different layout while maintaining the document content as it is? It used to be so easy in that other word processor!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Label Format (Word 2000)

    Hi Bernadette:
    When you did a mail merge, you had 3 documents: a datasource, a main document, & the merged document. Don't work with the latter.
    1. Open the main document.
    2. Click on the mail merge helper button on the mail merge toolbar.
    3. Click create & choose "Mailing labels". A dialog box will show giving you the choice of having a new main document or "change document type".
    4. You can use either option & you will have to insert your merge fields again.
    5. Then do another merge.

    Cheers,

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Changing Label Format (Word 2000)

    Regarding Phil's Step #4, if you display field codes (Alt+F9) in your old main document, you'll probably find the same merge fields in every cell. I don't see why you couldn't copy (carefully, you only want the cell contents and not the cell itself) and paste one complete group of them to each cell on the new document. Whether this is faster than inserting again, I couldn't say, but it is a potential timesaver if you have done something complicated (for example, with { IF } fields) and you're going to a smaller number of labels.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Label Format (Word 2000)

    Excellent point. In fact, if you copy the contents of one cell to the clipboard & then select the table in the new main document (except the "spacing" cells), you can run the following macro:

    Sub TableFill()
    '
    ' TableFill Macro
    ' Macro created 5/12/01 by Allen Wyatt
    Dim TargetRange As Range
    Dim oTargCell As Cell

    If Selection.Cells.Count = 0 Then
    'Quit if no cells in selection
    MsgBox "No cells selected", vbCritical
    Exit Sub
    End If
    On Error Resume Next
    Set TargetRange = Selection.Range
    For Each oTargCell In Selection.Cells
    oTargCell.Range.Paste
    Next oTargCell
    TargetRange.Select
    End Sub

    (Not often I get a chance to post a macro in response to one of your posts. But, of course, I got it from someone else.) <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •