Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Unanswered: Avery Mail Labels

    Hi,
    I'm running a report that generates Avery mail labels. Is there some way to choose the location on the label sheet that a given address prints? The software always assumes that you're starting with the label in the upper left-hand corner of the sheet. However, if you have already used half the sheet of labels, this can be a problem. Any thoughts?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    67
    As always, I recommend a book rather than paste lots of code.

    The exact solution you are looking for is found in the following book in Chapter 9 starting on page 692.

    Highly Recommend
    Access 2000 - Developer's Handbook (Volume 1: Desktop Edition)
    Sybex
    ISBN: 0-7821-2370-8
    $50 - $60


    Don't do today, what can be done tomorrow.

  3. #3
    Join Date
    Dec 2001
    Posts
    79
    Try using Label Saver:

    http://www.peterssoftware.com/ls.htm

    Label Saver is a freeware MS Access module that will allow your users to specify a label printing start position and a number of copies of each label to print. Using Label Saver means you don't have to throw out that half-used sheet of labels. Just continue printing from the next available label!

    Hope this helps,
    Peter De Baets
    Peter's Software - Microsoft Access Tools for Developers
    http://www.peterssoftware.com

  4. #4
    Join Date
    Aug 2002
    Posts
    121
    Thanks folks.

Posting Permissions

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