The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Addresses in Excel- can I export to labels in Word?

    Discussion in 'Windows OS and Software' started by allfiredup, Feb 21, 2012.

  1. allfiredup

    allfiredup Notebook Virtuoso

    Reputations:
    1,482
    Messages:
    3,209
    Likes Received:
    17
    Trophy Points:
    106
    I'm working on sending out 100+ letters for a fund raiser and I have most of the names and addresses in an Excel spreadsheet. Is there a way to export them to Word and create address labels???

    Any help will be appreciated! BTW, I'm using MSO 2003.

    Thanks! :)
     
    allfiredup, Feb 21, 2012
    #1
  2. Greg

    Greg Notebook Nobel Laureate

    Reputations:
    7,857
    Messages:
    16,212
    Likes Received:
    58
    Trophy Points:
    466
    If you use a Mail Merge you can quickly make any number of labels you need. The only trick is printing...I'm pretty sure you have to use the Mail Merge print wizard...the standard print command only prints the first page of labels.
     
    Greg, Feb 21, 2012
    #2
  3. yalcin19

    yalcin19 Notebook Consultant

    Reputations:
    66
    Messages:
    138
    Likes Received:
    0
    Trophy Points:
    30
    Copy & paste
     
    yalcin19, Feb 21, 2012
    #3
  4. TreeTops Ranch

    TreeTops Ranch Notebook Deity

    Reputations:
    330
    Messages:
    904
    Likes Received:
    124
    Trophy Points:
    56
    Mail Merge is much more elegant.
     
    TreeTops Ranch, Feb 21, 2012
    #4