Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    222
    Thanks
    37
    Thanked 0 Times in 0 Posts

    Merge to directory

    I am not sure if I should be addressing this in the spreadsheet or the Word forum. I am looking to merge names, addresses, phone numbers into a small directory and the entries have to be read vertically, not horizontally. I put something together in Word using an address label template and merge fields, but it always prints horizontally. Is there a way to do this in Word or Excel (I'm using 2007) so the entries read down in columns?

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,954
    Thanks
    62
    Thanked 1,104 Times in 1,027 Posts
    Change the label template to portrait instead of landscape?

    cheers, Paul

  3. #3
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,201
    Thanks
    2
    Thanked 462 Times in 381 Posts
    Word Label merges output the records using an across-then-down arrangement. If you need a down-then-across arrangement:
    1. In the Labels dialog, click New Document to create a new document based on the label definition you have chosen.
    2. Display table gridlines (Table Tools | Layout | Table | View Gridlines) and nonprinting characters (Ctrl+* or Home | Paragraph | Show/Hide ) so you can see what you're doing.
    3. Delete all cells except the first. If there is a spacer column, note its width beforehand.
    4. On the Page Layout tab, in the Page Setup group, click Columns and choose More Columns...
    5. In the Columns dialog, select however many labels across your label stationery had
    6. In the Spacing box, set the width to the original spacer column width or, if it had none, 0
    7. If necessary, set the column width to your label width.
    8. Change the mailmerge type to 'Directory'.
    9. Run the mailmerge.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. The Following User Says Thank You to macropod For This Useful Post:

    k32rem (2017-07-13)

  5. #4
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    222
    Thanks
    37
    Thanked 0 Times in 0 Posts
    Okay, I will try this! Thanks!

  6. #5
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    222
    Thanks
    37
    Thanked 0 Times in 0 Posts
    OK, I think I followed your directions to the letter, but I must have done something wrong. It fills down beautifully, but I'm getting only one column per page. I selected three labels across in the Columns dialog box, along with the spacer column width. What do you suppose I did? Thanks in advance

  7. #6
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,201
    Thanks
    2
    Thanked 462 Times in 381 Posts
    That suggests you didn't modify the page layout to use multiple columns.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  8. #7
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    222
    Thanks
    37
    Thanked 0 Times in 0 Posts
    Are you referring to item #5 in our instructions? If so, I chose "More Columns" and chose three columns. Maybe I should attach my file so you can see where I'm going wrong? Also, I am now using Office 2013, if that makes a difference?

  9. #8
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,201
    Thanks
    2
    Thanked 462 Times in 381 Posts
    Perhaps you could attach a copy of your mailmerge main document to a post (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  10. #9
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    222
    Thanks
    37
    Thanked 0 Times in 0 Posts
    I am attempting to upload the main document for my mail merge. However, I don't know if it's my system or a problem in Windows Secrets at the moment, but when I click to attach the file, everything in the box seems to be formatted improperly. It won't let me click on the "add files" box to add my file and things jump around, depending on what I click on. I'm going to give it a break and try another day. Just wondering if it could be my system (although everything else seems fine) or something on the other end.

  11. #10
    Super Moderator macropod's Avatar
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,201
    Thanks
    2
    Thanked 462 Times in 381 Posts
    There have been a few problems with the Lounge display. It should be working well enough now for you to attach something.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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