Printing labels from excel

[Guru]

As a regular job I have to take Name and Address details held in excel and print them onto labels.
The excel sheet is in the format: - Column a=Title b=First name c=Second name d=First line of Address etc.

I currently copy/paste the individual cells into a label template in word.

Is there a quicker way?

 

[WillR]

On 2003-02-21 05:18, Guru wrote:
As a regular job I have to take Name and Address details held in excel and print them onto labels.
The excel sheet is in the format: - Column a=Title b=First name c=Second name d=First line of Address etc.

I currently copy/paste the individual cells into a label template in word.

Is there a quicker way?

you should be able to accomplish this fairly straighforwardly with a mail-merge

open Word and goto Tools|Mail-Merge...

there's an option to create mailing labels

you can select the data source as XL worksheet & just follow the instructions from there...

HTH