• Post Reply Bookmark Topic Watch Topic
  • New Topic
permaculture forums growies critters building homesteading energy monies kitchen purity ungarbage community wilderness fiber arts art permaculture artisans regional education skip experiences global resources cider press projects digital market permies.com pie forums private forums all forums
this forum made possible by our volunteer staff, including ...
master stewards:
  • Carla Burke
  • Nancy Reading
  • r ranson
  • John F Dean
  • Timothy Norton
  • paul wheaton
  • Jay Angler
stewards:
  • Pearl Sutton
  • Anne Miller
  • Tereza Okava
master gardeners:
  • Christopher Weeks
gardeners:
  • M Ljin
  • Matt McSpadden
  • Megan Palmer

shipping labels?

 
steward & author
Posts: 42749
Location: Left Coast Canada
15859
9
art trees books chicken cooking fiber arts
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I want to print addresses on stickers.  A different address per person.

how do I do this?  If I do it by hand, I'll have errors.  But I have stickers that are two stickers per letter size paper.  I want to copy-paste the addresses into something and then print them.  What do I tell google to learn how to do this?
 
steward
Posts: 4837
Location: West Tennessee
2445
cattle cat purity fungi trees books chicken food preservation cooking building homestead
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Maybe input addresses into a spreadsheet in a grid? If I'm reading your question correctly, you have two jumbo stickers per 8-1/2x11 sheet, but want many addresses per sticker to then cut with scissors?
 
gardener
Posts: 2564
Location: Ladakh, Indian Himalayas at 10,500 feet, zone 5
890
trees food preservation solar greening the desert
  • Likes 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
When I used to have to print address stickers, I'd put all the addresses in MS Word, set the document to 3 columns, check that none are cut in half at column breaks, and then print them on sticker paper and cut them by hand.

 
pollinator
Posts: 336
Location: Near Philadelphia, PA
74
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You want to do a mail merge from software like Open Office (free!). Basically, you set up a spread sheet or list of your information and then put data fields onto a page that mimics your labels, and off you go!

(Google mail+merge+open+office to see info, instructions and even videos of how to do this!) :>)
 
steward
Posts: 6601
Location: Everett, WA (Western Washington State / Cascadia / Pacific NW)
2188
8
hugelkultur purity forest garden books food preservation
  • Likes 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
When we order labels online from usps.com or pirateship.com (both in the U.S., of course - though maybe pirateship does Canada?), they print out on the two labels per page format.

Or, if you aren't doing that, or don't want to do a spreadsheet merge with a word processor, or figure out all the columns and such, it can be easier to find the corresponding label template in your word processor.

It's often under "envelopes and labels" and will usually let you choose from a big list of labels.
 
But why do you wear your googles indoors? While holding this tiny ad?
Switching from electric heat to a rocket mass heater reduces your carbon footprint as much as parking 7 cars
http://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic