Printing labels

I am trying to work out how to print labels.  They are not for addresses, just a filing system.
Is it best to create them as addresses, and do a mail merge?
«1

Comments

  • Are you printing with a label printer, or on to an a4 sheet of multiple stickers?
  • A4 sheet with stickers. 
  • Cornucopia
    Cornucopia Posts: 16,434 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    edited 20 September 2020 at 10:36PM
    If you can find a label printing option in one of your apps that fits your labels, then use that.  (You don't necessarily have to use mailmerge).   

    Alternatively, and especially if you want more complex designs, you might want to set up your own template in a drawing package (MS Paint is probably easiest for pixel-wise positioning).    What size/layout are your sheets - I have several templates that I use that I could post here.
  • If you use Avery A4 label stationery you would be able to use the functionality within Microsoft Word to produce your labels dependent on the relevant Avery product code.
    I set this up on my own computer some time ago for Xmas card labels and it works perfectly.
    I can’t recall the precise steps to take in order to create the document merge, but it didn’t take that long and the process was quite intuitive.
  • If you’ve got Microsoft Publisher, that works well for labels, as you can divide the page up into a 6 by 4 grid (or whatever). 

    would've . . . could've . . . should've . . .


    A.A.A.S. (Associate of the Acronym Abolition Society)

    There's definitely no 'a' in 'definitely'.
  • mart44
    mart44 Posts: 219 Forumite
    Part of the Furniture 100 Posts
    I found sheets of labels are OK to do in Word or other installed program. It was when it came to wanting one label and the next available one was in the in the middle of a sheet. Printing a label wasn't so quick then. This lead to getting a Dymo LabelWriter. It wasn't cheap but it is a convenient way of printing labels. Choose the address from the list or write the text, click print and out reels the label.

    The Brother VC-500W printer is good for reeling out artistic coloured labels of your own design.

    Error! - Keyboard not attached. Press any key to continue.
  • Le_Kirk
    Le_Kirk Posts: 24,138 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    If you want to print one label, use M$ Word, type the text in the top left hand corner, highlight it, click on Mailings and then Labels, click on Single Label and select the next available column or row on your sticky A4 label sheet.  Depending upon your printer, you maybe ale to print using the rear feeder slot or you might have to place the labels in the main tray, upside down usually.  Have a care for the font type and size.  Generally when you preview the label, if it fits in the box on the screen, you should be OK.
  • If you can find a label printing option in one of your apps that fits your labels, then use that.  (You don't necessarily have to use mailmerge).   

    Alternatively, and especially if you want more complex designs, you might want to set up your own template in a drawing package (MS Paint is probably easiest for pixel-wise positioning).    What size/layout are your sheets - I have several templates that I use that I could post here.
    I am using A4 sized sheet with 14 labels.
  • Cornucopia
    Cornucopia Posts: 16,434 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    edited 21 September 2020 at 3:32PM
    BriNylon said:
    I am using A4 sized sheet with 14 labels.
    I have labels in 2 x 7 format, and the template is this (for use in MS Paint).   The idea is that you cut & paste text from a spreadsheet into each label frame, and then use the bucket tool with white fill to remove the frames before printing.   On my printer, I use A4, 0 Margins, 100% scaling, Portrait and no centring.    It probably won't line up perfectly, but if the text is kept to the middle of the label area, could be an easy way to get started.

    If you right-click the image below and use either Copy Image or Save Image as it should download at the correct size.

  • jon81uk
    jon81uk Posts: 3,877 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Combo Breaker
    Go into Word, then on the ribbon menu choose Mailings then labels.
    In the pop-up select the type of label by clicking on the current type in the lower right box.
    then click new document at the bottom.

    This creates a table filling the page of the correct layout for the label size, you can then type whatever you like into each box of the table.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 349.8K Banking & Borrowing
  • 252.6K Reduce Debt & Boost Income
  • 453K Spending & Discounts
  • 242.7K Work, Benefits & Business
  • 619.5K Mortgages, Homes & Bills
  • 176.4K Life & Family
  • 255.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 15.1K Coronavirus Support Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.