Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: printing address labels

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I maintain a 2700 member roster on Excel and need to know if I can print Members address labels from the worksheet. Cant seem to find any info in Excel publications.

    Mac Maginnis

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Easy thing to do, do a mail merge with Word. Excel does not provide a built in feature for this.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Agreed.

    Here's complete instructions on how to mailmerge with Word to Excel:

    http://www.thewordexpert.com/word.htm#MailMerge
    ~Anne Troy

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-27 10:23, tacomamac wrote:
    I maintain a 2700 member roster on Excel and need to know if I can print Members address labels from the worksheet. Cant seem to find any info in Excel publications.

    Mac Maginnis
    Hi Mac:
    Juan Pablo and Dreamboat have already given you a good solution using Word. In case you want to work this from within Excel, you can do this using the Index Function and concatenate various items that make up a record. As Juan has correctly pointed out, working from within Excel will require setting up at least one label, and may be a set of labels before you can get going with it. It is going to take a bit of effort to learn the setup but once you have it figured out, I am sure Excel will do the job to your satisfaction.

    HTH
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you will know i love excel she is wonderful and beautiful,,, but she retired from the lables,,, her sister WORD cover this,,,,

    After Dreamboat pointing to a few ideas, mt hate for word is less Lables and mail merge she loves.. but batch mail merge i would still aks my lover Excel to do.. as i feel she does the with sex, and offers tweaks word can not.

    Use word my friend...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    did you have a winner?

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

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
  •