Label printing

gears

I may not be in the right section with this question so I hope the mods will forgive me and move it.

Basically I'm wondering if any one knows how to using MS software or if there's a piece of (preferably) free software where I can take my all Outlook contacts which I also have in Excel with name, address etc in seperate columns and transfer them to a format where I can print postage labels.
What I'm doing at the moment is using an A4 page which has 21 (3 wide 7 high) labels and simply using copy and paste, which is fine for a 1 off but for a new project I need to do a lot more on a regular basis.

Any help would be great.Thanks.

BoB_BoT

you can use mail merge from within outlook to print your contact details to stickers. select the contacts you want to send to, click tools (top of the screen) then mail merge. follow the instructions from there on.

CCSL

You will have to tell word the labels you are using - Avery no or what ever brand you have.

If you end up manually entering the dimensions be careful as over a large batch pring if you are out the labels will creap down the page.

gears

Thanks for the help guys. I eventually got it to work and (to me) it's an great time saving little application.

muinteoir83

Hi there

Just wondering can anyone help..... I'm lost!!:o:confused:

I have a list of about 200 ppl that must get invites in the next week or two... list is saved on microsoft word and i have pro:form 99.1mm * 38.1mm address labels ( 14 labels per sheet)

What would be the quickest way to get them all lined up in the correct way and printed!!



Appreciate any help!:rolleyes:

liamo

You say the list is saved in a MS Word document? Use MS Word to do a mail-merge to labels.

The list needs to be in a table in the document. If not, you've got some copying and pasting ahead of you to tabulate it in that document or into an Excel document.

Assuming Word 2007 : Mailings - Start Mail Merge - Labels.

muinteoir83

Thanks