Printing address labels from an Excel spreadsheet.

</p>

Any ideas re a program? </p>

TIA</p>

 

Do it in Excel mate

...

 

Great stuff. Cheers. nt

 

I've only got Norwegian Excel here mate

But "Help" in excel gives you a step by step explanation.

 

You could try importing it into Outlook nt

 

Is it worth it for a couple of Christmas cards ? nt

 

</p>

You need to go on a course at college mate !!!! They're good at owt like that.....</p>

 

Why Excel & not Avery

Free Avery templates here,

http://www.avery.co.uk/avery/en_gb/Templates-&-Software

 

try this

http://office.microsoft.com/en-us/excel/HP052037601033.aspx

 

Try writing the envelopes by hand

yer lazy git!

 

Word?

Google search for "Excel Address Labels" gives you a million and one guides.

 

Definitely via word. Give me 20 mins and I'll try and remember how I did it last time I needed to.

 

Okay this is in Word 2003

open a new document in word, click on Tools/Letters and Mailings/Mail Merge.... select labels then click 'next'.

Then opt for 'change document layout' and click 'label options' Select the kind of labels you are using from the extensive list and this will format the page to print within the label guidelines.

Once you've select the label type, click 'next' select recipients. Opt for 'Use an existing list', then browse for your excel document. select which sheet the info is on. (Normally sheet1), then have a play in sorting it out. Before you do this, it's worth heading up each column in the excel document. Name, Street name, Address 1, Town, Postcode etc. It makes it easier to sort.

To sort it out select ''Next arrange labels', then' opt for 'more items' which should mirror the excel spreadsheet headings you've made.

Align them in the first label, like this for example.

«Name»
«Address_1»
«Address_2»
«Address_3»
«Address_4»
«POST_Code»

Then 'update all labels' and then preview.

You can go back and forth to sort out formatting and change font size to make it fit to the label size you're using.

I hope that's useful, no doubt in the time I've had to learn how to do this in Word 2003, someone else has responded in English..

 

Use Word and do a mailmerge nt

 

Should have read this one 1st

 

Thanks everybody. nt