Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Oct 2003
    Location
    NORTHWICH, Cheshire, England
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Making tickets from a label template (2000 SP3)

    I have two queries about labels in MS Word 2000.

    I am using an Avery template, J8414-Card that has 10 labels per sheet, to make tickets for an event. I get as far as selecting the template, creating the Sample Label & closing the MailMerge Helper. The template then has the ticket text in the ten labels while the instructions I am following tell me that the text should appear only in the first label. This is to give an opportunity to fine tune the layout, formatting etc of the text. When satisfied to copy the text to the other labels one is to click Update All Labels. But I cannot find that command or a button for it.

    Perhaps this command is a feature of a later version of Word. I would be very glad of some assistance in this matter.

    Malcolm Walker

  2. #2
    4 Star Lounger
    Join Date
    May 2002
    Location
    Australia
    Posts
    549
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making tickets from a label template (2000 SP3)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> I use labels quite often, all I do is go into>envelopes and labels, select LABELS, and type the details I want. Just under the details box there is an option for "full page of same label" or "single" label. HTH

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

    Re: Making tickets from a label template (2000 SP3

    Hi Malcolm:
    You can make labels doing a mail merge. When you open the mail merge helper & click "Create", you then choose Labels. Once you choose Labels, a dialog box opens in which you insert merge fields. This dialog box is the one for creating the "single" label. Once you merge, you will create a set of labels, 1 for each record.
    Cheers,

  4. #4
    Lounger
    Join Date
    Oct 2003
    Location
    NORTHWICH, Cheshire, England
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making tickets from a label template (2000 SP3)

    Thank you for replying.

    Yes indeed I am aware of how to make a sheet of labels. It is the location of the command to Update All Labels I am seeking guidance on. In addition each label is different as they are numbered from 1 to 250. That is why I am using MailMerge with a database creating in MS Excel.

    Malcolm Walker

  5. #5
    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: Making tickets from a label template (2000 SP3)

    >Perhaps this command is a feature of a later version of Word.

    It is mentioned in instructions for Word 2002 (e.g., HOW TO: Use Mail Merge to Create Mailing Labels in Word 2002 (MSKB 294684)), but not for Word 2000 (e.g., HOW TO: Create Mailing Labels by Using Mail Merge in Word 2000 (MSKB 212034)). Perhaps the second document is all you need?

  6. #6
    Lounger
    Join Date
    Oct 2003
    Location
    NORTHWICH, Cheshire, England
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making tickets from a label template (2000 SP3

    Hello Phil,

    Thank you for your reply; would you have a look at this procedure please?

    I open Word & go to MailMerge & select Create | Mailing Labels | New Main Document. Then I proceed to select a database a worksheet in MS Excel 2000 that has 250 rows that are numbered 1 to 250. That is the number of tickets I want to make. All the rest of the data is in the remaining columns such as date, time, venue, price etc. After selecting the worksheet a MS Excel dialogue box opens that allows the worksheet to be selected & I click OK for the Entire Spreadsheet. Then MS Word opens a dialogue box with a button to Set up Main Document. Clicking that button opens the Label Options dialogue & I select the label template I wish to use (Avery A4 & A5 sizes | J8414-Card) & click OK. Another box opens named Create Label with a button to Insert Merge Field & with this I set up the Sample Label that with a right click I can format. So far so good but then the problems start.

    Clicking OK reveals the Mail Merge Helper & behind it is the label template with the contents of the Sample Label in each of the labels. This is problem 1 as the instructions tell me that the contents of the Sample should only appear in the first label to give an opportunity for those contents to be fine tuned. Then when finished I am told to Update All Labels, which is the command I cannot find, to fill the rest of the labels with the finished content from the Sample Label. In the right click menu there is a command to Update Fields but that doesn't have the effect I need. So that is problem 2.

    If you can offer any help or even an alternative I would be very pleased.

    Malcolm Walker

  7. #7
    Lounger
    Join Date
    Oct 2003
    Location
    NORTHWICH, Cheshire, England
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making tickets from a label template (2000 SP3)

    Thank you for pointing out that the facilty exists in Word 2002 & not in Word 2000. The solution for me will be to put the numbers on the reverse of the tickets. In that case I can manage the whole task in Word 2000 without resorting to MailMerge!

    I hadn't realised that such practical & useful information existed in the MSKB!

    Malcolm Walker

  8. #8
    Lounger
    Join Date
    Oct 2003
    Location
    NORTHWICH, Cheshire, England
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making tickets from a label template (2000 SP3

    Phil,

    With the information that the facility I was seeking does not exist in Word 2000 please accept my thanks for your interest. You will see in another excahange that I have decided to do the task entirely in Word without using MailMerge.

    Malcolm

  9. #9
    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: Making tickets from a label template (2000 SP3)

    > I hadn't realised that such practical & useful information existed in the MSKB!

    It does tend to get buried under all the bug fixes... almost all of these kinds of articles can be selected by searching for HOWTO or KBHOWTO somewhere in your query (either at microsoft.com or at Google, with the additional search term site:microsoft.com).

Posting Permissions

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