Creating Labels 21 per page for the same addressee in Office 2010

15 pts.
Tags:
Creating Labels
office 2010
Office Applications
I'm trying to create labels, 21 per page of the same addressee from a table. There are 5 rows on each label. If an address only needs 4 rows they shrink and print out of alignment. How can I stop this? Desperate



Software/Hardware used:
Microsoft Office 2007 - Office

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Chippy088
    Well you don't mention which of the office apps you are using to do it. Word or excel. Either way, I'd use a 5 cell area with a formula that works something like this. if address line is a blank, then address line = chr(32) which is a space and will be the place holder. It will not print anything, but it does enable passing 5 lines of address. I use this in an excell spreadsheet I created for a friend to add addresses to his invoices.
    =IF(VLOOKUP(Invoice!$C$1,Customers!$A$2:K300,5,FALSE)=""," ", (VLOOKUP(Invoice!$C$1,Customers!$A$2:K300,5,FALSE)))
    
    You will see that it looks for an address line, and if the line is blank then the string, passed to the address line for printing, is just a space (see the bold text.) This is done entirely in excel. You should be able to do the same in word, you will just have to find the equivalent formula.
    4,625 pointsBadges:
    report
  • Chippy088
    Ok, that did not show the entire code used. Not sure why. So I'll try it again. So here it is broken down into smaller chunks.
    =IF(VLOOKUP(Invoice!$C$1,Customers!$A$2:K300,5,FALSE)="",
    " ",(VLOOKUP(Invoice!$C$1,Customers!$A$2:K300,5,FALSE)))
    All this needs to be entered in the address line cell you want to print, and the line will be printed even if it is blank in the cell.
    4,625 pointsBadges:
    report
  • PTyler
    Thank you Chippy I thought I had chosen Access when I first started my inquiry, sorry. We kept playing with it and found a solution. We are creating one label with instructions to duplicate. thanks for offering your help. regards PTyler (Australia)
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following