Results 1 to 2 of 2

Printing labels from excel

This is a discussion on Printing labels from excel within the Excel Questions forums, part of the Question Forums category; As a regular job I have to take Name and Address details held in excel and print them onto labels. ...

  1. #1
    New Member
    Join Date
    Nov 2002
    Posts
    5

    Default

    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?

  2. #2
    Board Regular WillR's Avatar
    Join Date
    Feb 2002
    Location
    Sutton Coldfield
    Posts
    1,143

    Default

    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
    /**\ Regards, Will /**\

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com