Share via

Avery 5567 Hanging File Tabs

Anonymous
2017-12-28T21:35:28+00:00

I am having problems with using Avery 5567 hanging file tabs.  When I download the template it looks great but when I try to select recipients and merge onto full sheet of tabs it will only put one per page.  Also, having problems with text going in vertical instead of horizontal on tab.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2017-12-30T00:09:01+00:00

    One the Mailings tab of the ribbon:

    1. From the Start Mail Merge dropdown, select Labels
    2. In the Label Options dialog that appears, select Avery US Letter as the label Vendor and then select the 5567 Hanging File Folder Labels from the Product Number list and then click on OK
    3. From the Select Recipients dropdown, select Use and Existing List and browse to and select your data source.
    4. With the selection in the first label on the sheet, use the Insert Merge Field dropdown in the Write & Insert Fields section to insert the required merge fields into that label.  Here, I selected the Name field in my data source, so my document then looks like:

    5. Then click on the Update Labels button (shown in my earlier response) and the document will then look like

    6. If you want the text on the labels to run in a different direction, use the Table Tools>Layout>Select>Table button to select the table

    7. Then use the Table Tools>Layout>Text Direction facility to change the orientation of the text

    8. So that your document then looks like

    9. Then use the Finish & Merge facility to execute the merge.

    If you still have a problem, send me the files and I WILL sort it out for you.

    7 people found this answer helpful.
    0 comments
  2. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2017-12-28T23:50:30+00:00

    Genevieve Cri,

    If you do not understand the issue and know the reason for it, please refrain from disseminating such advice and just leave the question alone.

    2 people found this answer helpful.
    0 comments
  3. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2018-01-02T07:08:46+00:00

    Based on the email message that I received, Margie had omitted the step 6 of my instructions to select the whole table before changing the text direction.

    1 person found this answer helpful.
    0 comments
  4. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2017-12-29T03:57:00+00:00

    Margie,

    You should IGNORE the blatantly misleading "advice" posted by Genevieve.   She has absolutely no clue!

    Rather, take a look at the response that I made to your post about using the Update Labels button.

    If you still have a problem, send me the files and I WILL sort it out for you.

    1 person found this answer helpful.
    0 comments
  5. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2017-12-28T23:48:09+00:00

    After inserting the merge fields into the first cell on the page, you must use the Update Labels button to replicate that setup to the other cells on the page.

    Finally, you must select a destination for the merge from the Finish & Merge drop down in the Finish section of the Mailings tab of the ribbon.

    1 person found this answer helpful.
    0 comments