Label codes to accomodate addres for C5 envelopes

Say, I wish to address labels, C5 in size with labels. Kindly suggest label sizes readily available in South Africa that would accommodate this. The labels to be printed on a deskjet HP930C or a laser printer
shaunwinginAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hdhondtCommented:
C5 is an envelope size. A5 is the equivalent paper size. What size are the labels you want to print?

In Word, if you go to Mailings > Labels > Options you can see the label sizes available from most vendors. In that list, you should be able to find labels that are available in South Africa, and are the size you require. Many will come on A4 sheets, but other sheet sizes (including American sizes) are also listed..
shaunwinginAuthor Commented:
Say label to be about 2.2cm in height X 5cm in width
Can you suggest options?
hdhondtCommented:
Here are some examples from the Avery labels list in Word:

L41615 is 2.5 x 5.3 cm
L4736 is  2.12 x 4.57 cm
L4770 is  2.54 x 4.47 cm

All of these come on A4 or A5 sheets
Webinar: Cyber Crime Becomes Big Business

The rising threat of malware-as-a-service is not one to be overlooked. Malware-as-a-service is growing and easily purchased from a full-service cyber-criminal store in a “Virus Depot” fashion. Join us in our upcoming webinar as we discuss how to best defend against these attacks!

shaunwinginAuthor Commented:
Say I've found this
http://autolabels.co.za/templates2013/autotape22.dotx

Label 22 at
http://autolabels.co.za/download2013.htm

What is equivalent pre-loaded lable?
How can I setup this label in word 2013 to perform a mail merge?
I normally battle with choosing correct labels and setting up a mail merge.
tx
hdhondtCommented:
Your second link explains how to do it: just open the .dotx file in Word, and the template will be available. However, there seems to be something wrong with the templates, at least on my PC: Word cannot open them.

There is another way you can do it, if you know all the dimensions of the label sheet (i.e. label size, margins, spacing between labels...), as follows.

Go to Mailings > Labels. Click Options and then New Label. Type in the required measurements. Make sure you select the correct Page Size (A4).

Note that, although the little image in your link does not show margins, there must be some, as 52 and 26 do not divide evenly into 210 and 297. Also, printers do not print to the edge of the paper. Most require at least 5 mm. Assuming there are no gaps between the labels, here are the margins you need:

Left (and right) margin = (210 - 52*4)/2 = 1mm. This is not enough for any printer, so make sure you leave some blank space at the left and right side of the label text.

Top (and bottom) margin = (297 - 26*11)/2 = 5.5mm

The attached image shows the settings I typed into Word.
Label.jpg
shaunwinginAuthor Commented:
Tx - the manual method looks the way to go and you have given some great details. We using HP930C printer - can you please check what margins are needed - I battle to set this up.
Kindly can you do the calculations for the 70x50mm - label no 12. Can you see the spacings required from their site?
hdhondtCommented:
I've attached the settings. Note that these labels do not quite fit on A4. Horizintally they just fit: 3 x 70 mm = 210 mm, which is the width of an A4 sheet. Vertically you do not have enough room: 6 x 50 = 300 mm, compared to an A4 sheet which is only 297 mm high.

Hence, it's up to you to ensure you position your text inside the labels in such a way that it will be in your printer's printable area. If you don't know them, you can check them, as follows. In Word, go to Page Setup and set all margins to 0. Click OK, and Word will ask if they should be adjusted to the printer's margins. Click OK, and Page Setup will then be set for your printer's real margins.
No-12.bmp

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shaunwinginAuthor Commented:
Tx - Even with adjusting Page Margins to 0 and choosing Ignore the custom label won't create. Message paraphrased is that "labels down (6) produce a page that is larger than the label page size". Any suggestions?
hdhondtCommented:
I can't offer any fixes for that. If Word is unwilling to create the page (rightly so, because it really does not fit), there is not much you can do - except choose a different label.

You could try making the label height 29.7/6 = 4.95 cm. That way they fit. However, as the real labels are 5.0 cm you will find that the text will creep upwards on the labels as you go down the page, since each successive row of labels is 0.5 mm lower than on the Word page.
shaunwinginAuthor Commented:
I found a setting to adjust page size and just increased it. Tx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Printers and Scanners

From novice to tech pro — start learning today.