1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

excel question

Discussion in 'Other PC Software' started by moco123, 2003/11/07.

Thread Status:
Not open for further replies.
  1. 2003/11/07
    moco123

    moco123 Inactive Thread Starter

    Joined:
    2002/06/14
    Messages:
    62
    Likes Received:
    0
    i need to know if i can take a spread sheet that was given to me with name, address, city etc...column a has name, column b the adress etc and somehow change it to print labels
     
  2. 2003/11/08
    merlin

    merlin Inactive

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    You can import the XL data to an Access table and then create a Report to do this.
    regards
     

  3. to hide this advert.

  4. 2003/11/08
    Laage

    Laage Inactive

    Joined:
    2002/01/15
    Messages:
    106
    Likes Received:
    0
    Personally I'd say using Access for such a task is overkill.

    I'd just go via Word, if you go to Tools -> Letters and Mailings -> Mail Merge you should get a Wizard guiding you through creating Address Labels by using an external source, and it should accept just about anything as source including an Excel worksheet.

    Please note that the description is based on Word 2003, and it might look slightly different in your version - but Mail Merge has been in Word since at least version 97 so it shouldn't be too hard to find.
     
  5. 2003/11/18
    moco123

    moco123 Inactive Thread Starter

    Joined:
    2002/06/14
    Messages:
    62
    Likes Received:
    0
    still need help

    Thanks for your efforts but Word did not do it at all

    What is this Access I am running Me.

    Any other thoughts or ideas.

    I guess Excell will not take several columns and print labels?
     
  6. 2003/11/18
    Newt

    Newt Inactive

    Joined:
    2002/01/07
    Messages:
    10,974
    Likes Received:
    2
    MS Access is a database that is part of Microsoft Office - at least some versions of Office.

    Excel can certainly send data to Word and create labels. At least my version can. Try Excel help and search for print labels. One topic you should see is Create a Word mail merge with Excel data.
     
    Newt,
    #5
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.