+ Reply to Thread
Results 1 to 3 of 3

Printing to Avery Labels # 5871

  1. #1
    Registered User
    Join Date
    04-22-2015
    Location
    Austin, TX
    MS-Off Ver
    2010
    Posts
    30

    Printing to Avery Labels # 5871

    With the help of this site I have the attached workbook. My company is now looking to take these certificates and print them onto Avery Labels # 5871 (Business cards) for people to put in the wallets. The cards are 2" x 3 1/2" and i am trying to see if there is a way to shrink the certificate to that size or do i have to redo the cert? I am thinking i may have to re-do the cert into tiles that would match up to the avery sheet. But I am not sure if there is a faster way to do this.

    The avery sheet is 10 cards to a sheet. 2 columns and 5 rows of these 2" x 3 1/2" cards.

    Attached is the cert itself and the avery template, any feedback or help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,268

    Re: Printing to Avery Labels # 5871

    Refer both attachment.
    Kindly remove merge cell & resize in excel.
    Copy from excel file & in word file paste it.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    04-22-2015
    Location
    Austin, TX
    MS-Off Ver
    2010
    Posts
    30

    Re: Printing to Avery Labels # 5871

    I was hoping to keep some of the auto fill fields in the process so I didn't have to fill in the fields manually. I guess I need to resize it and and get the fields to pull date from the primary cells.

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Merging Avery 5160 labels from excel to word
    By ashleygf in forum Excel General
    Replies: 2
    Last Post: 05-01-2015, 07:00 PM
  2. Printing Avery Labels in Word using an Excel Doc
    By jonkuhl in forum Excel General
    Replies: 0
    Last Post: 11-17-2012, 06:58 PM
  3. printing onto Avery labels like Word does
    By carsto in forum Excel General
    Replies: 0
    Last Post: 10-04-2011, 02:06 PM
  4. Data List to Create Labels (Avery 5660)
    By eric_1487 in forum Excel General
    Replies: 1
    Last Post: 02-25-2009, 11:31 AM
  5. How do I print my excel contact sheet into avery labels
    By madison in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2006, 08:40 AM
  6. How can I generate avery address labels from database
    By Abdool Rahim in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-27-2005, 04:05 PM
  7. Producing Avery labels in Excel
    By Anthony in forum Excel General
    Replies: 1
    Last Post: 04-08-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1