1. Attention: We have put together a thread with tips and a tutorial video to help with using the new software. Please take a moment to check out the thread here: Trapshooters.com Tutorial & Help Video.
    Dismiss Notice

Label addresses - duplicate copy needed

Discussion in 'Shooting Related Threads' started by Rollin Oswald, Jan 14, 2009.

Thread Status:
Not open for further replies.
  1. Rollin Oswald

    Rollin Oswald Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,313
    Location:
    Brillion, WI
    I use the addresses sent by PayPal to print labels to use for mailing books that are ordered. It works well but I also need a duplicate copy so I can note when the order was placed and when a book is or will be mailed.

    I now print labels on label sheets of 30 labels using MS Word. I then use Word to print the same address on a blank sheet of paper in the same position as was used on the label sheet.

    Just now, I failed to select the use of printing only one label and printed 30 of the same address on the plain-paper copy sheet used for my easily accessible order history.

    I am hoping that one of you computer wizards can suggest a better way to keep a copy of all the labels I print in a format that will allow me to add a line indicating when a book was or will be mailed.

    A sheet of labels, each with a carbon copy that remains in place on the label sheet would be ideal but I have not been able to find any. (I use a laser printer, which obviously cannot not make carbon copies.)

    Any suggestions you can offer will be sincerely appreciated.

    Rollin
     
  2. halfmile

    halfmile Well-Known Member

    Joined:
    Jan 29, 1998
    Messages:
    15,639
    Location:
    Green Bay Wisconsin
    The companies I do business with use "order numbers".

    Does your Paypal account track that stuff for you?

    HM
     
  3. JBrooks

    JBrooks TS Member

    Joined:
    Nov 6, 2006
    Messages:
    3,707
    Copy and paste your lable sheet on to a blank Excel spreadsheet.
     
  4. Rollin Oswald

    Rollin Oswald Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,313
    Location:
    Brillion, WI
    HM - I don't know if PayPal use "order numbers" and I've not heard of it before. They are changing things next month so I'll have to wait and contact them after the changes are made.

    JB - I would have to do it one label at at time as I create them. I may have Excel software on a disc but I'll have to check. I have never used it so that alone might be a problem.

    Thank you both for your suggestions.

    Rollin
     
  5. Smity

    Smity Member

    Joined:
    Nov 2, 2008
    Messages:
    70
    Rollin,
    Three ideas:
    You could use an MS Excel worksheet as a simple database, record your data and then build a label template in MS Word that links directly to your spreadsheet and prints each label twice, once for the package and once for your records.

    ...or you could use MS Access to create a database and build an Access Report that you could use to print the labels. The database would be your record keeping and you could always print a hard copy of your data if you are worried about computer failure.

    The simple, non tech savvy way, if your not familiar with Access and databases or linking templates, etc., would be to use a label printer. They are available at Staples for about $100. If you have one of those, you could just print the label twice, once for the package, and the other you could stick on a your 8 1/2 x 11 sheet of paper for your records.

    Smity


    [​IMG]
     
  6. 682LINY

    682LINY Member

    Joined:
    Aug 14, 2006
    Messages:
    967
    lable printer as shown is on sale at staples under 50 dollars
     
  7. Rollin Oswald

    Rollin Oswald Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,313
    Location:
    Brillion, WI
    HM - If the "order numbers" you speak of refer to "purchase orders," I have not used them.

    JBrooks & Smity - I have MS Office 2007 Home & Student that I bought to get a newer version of Word but I unstalled it because I hage Word 2007. I could not load just Excel without Word 2007, which screwed up Word 2002 that I bought Works Suite 2006 to get.

    The MS Access idea is so far over my head that I couldn't even see a vapor trail.

    The label printer seems like the way to go.

    682LINY - Where did you see the label maker for $50? Online, the ones I saw were $100.

    Rollin
     
  8. ivanhoe

    ivanhoe Well-Known Member

    Joined:
    Jan 29, 1998
    Messages:
    7,538
    Location:
    Oxford MA
    Rollin Microsoft Works itself should have a label section in it mine does and I would much rather use Works than word anytime. under tasks launcher it should say templates and in that address labels.

    Bob Lawless
     
  9. Rollin Oswald

    Rollin Oswald Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,313
    Location:
    Brillion, WI
    Bob,

    I use MS word now to print 30/page labels.

    What do you mean when you wrote "I would much rather use Words than word anytime.?

    When I called PayPal today, in foreign doublespeak, the woman seemed to say that something to the effect that I may not need to change anything and that I may have access to the address labels that I print without using a separate shoot of print paper to print them or use duplicate printing on label print paper.

    Thank you for your suggestions. I will wait until PayPal changes (improves) their system next month before further considering a Brother QL-550 (PayPal-required label printer.

    Rollin
     
  10. ivanhoe

    ivanhoe Well-Known Member

    Joined:
    Jan 29, 1998
    Messages:
    7,538
    Location:
    Oxford MA
    Sorry Rollin I was kind of distracted at the moment and typed the wrong word it should have said Works.

    Again I am sorry and I corrected it in my original post

    Bob Lawless
     
  11. Rollin Oswald

    Rollin Oswald Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,313
    Location:
    Brillion, WI
    Bob,

    I use MS word now to print 30/page labels.

    What do you mean when you wrote "I would much rather use Words than word anytime.?

    When I called PayPal today, in foreign doublespeak, the woman seemed to say that something to the effect that I may not need to change anything and that I may have access to the address labels that I print without using a separate shoot of print paper to print them or use duplicate printing on label print paper.

    Thank you for your suggestions. I will wait until PayPal changes (improves) their system next month before further considering a Brother QL-550 (PayPal-required label printer.

    Rollin
     
  12. ivanhoe

    ivanhoe Well-Known Member

    Joined:
    Jan 29, 1998
    Messages:
    7,538
    Location:
    Oxford MA
    Sorry Rollin I was kind of distracted at the moment and typed the wrong word it should have said Works.

    Again I am sorry and I corrected it in my original post

    Bob Lawless
     
  13. Rollin Oswald

    Rollin Oswald Active Member

    Joined:
    Jan 29, 1998
    Messages:
    1,313
    Location:
    Brillion, WI
    Not a problem, Bob. Your keyboard may be like mine - the positions of keys change from time to time. I try to type very fast to hit them before they have a chance to move but it doesn't seem to help much.

    I am considering trying to staple them in place so they can't move.

    Rollin
     
Thread Status:
Not open for further replies.