• New Agents
    • Technology Info Form
    • New Assistant Registration
  • Office
    • Associate Leadership Council
    • Daily Digest
    • Leadership Team
    • Marketing Compliance
    • On-Call Calendar - Northwest
    • On-Call Calendar - Yukon
    • Profit Share
    • Reserve a Room
    • Training & Events Calendar >
      • Click to Subscribe
  • Training
    • Chuck's YouTube Videos
    • Database Mastery
    • KW Elite Webinars
    • KW Placester Websites
    • KW Whitepages Profile
    • Trello for Real Estate >
      • Listing Transactions Example
      • Buyer Transactions Example
      • 8x8 Seller Example
      • 8x8 Buyer Example
      • 8x8 Business-to-Business
      • 411 Example
      • Trello Class Notes
    • Wes' YouTube Videos >
      • KW Command Videos
      • eEdge Videos
  • Help!
    • Email Scam Red Flags
    • How Does Syndication Work?
    • Update My OKCMAR MLS Info
    • Update My KW Elite Info
    • WWWB?
  • Services
    • Forward My Domain Name
    • Order KPA
    • KWELITETECH Services
    • eEdge Website Banner
    • eEdge Website Setup
    • KW + eEdge Website Setup
    • New Mac Setup
    • Upload My Contacts
  • Files
    • Bulk Mail Permits
    • eEDGE 101 Class Files
    • eEDGE myContacts Files >
      • eEDGE myContacts CSV File
      • eEDGE myContacts Help Sheet
    • Facebook Cover Photos
    • KW Command Files
    • KW Elite Classic Logos
    • KW Elite Modern Logos
    • KW Elite Letterhead
    • KW Fonts >
      • KW Modern Sans-Serif Font: Helvetica Neue LT Pro
      • KW Modern Serif Font: Adobe Garamond Pro
      • KW Classic Serif Font: Goudy Old Style
    • Office Print Drivers
    • Total Market Overview
myKWElite

Create Mailing Labels with Avery Design & Print Online

3/12/2013

Comments

 
How to create mailing labels is something I've been asked to help with by a few agents now. There's no way, currently, to perform this task using eEdge's myMarketing tools, and the most common way of creating mailing labels, using Microsoft Word, is fairly complex. In fact, creating mailing labels using Word requires the user to utilize both Microsoft Excel and Word by making them communicate via a tool called "mail merge".

The typical way to create mailing labels is to create an Excel spreadsheet full of contact information organized into columns, then begin a mail merge in Word that takes the data from the spreadsheet and reorganizes it into pretty sheets of labels. Microsoft's Word Blog explains how to perform a mail merge if you're at all interested in the terrible experience that awaits you.

It's a difficult task, and both times I've done it, Microsoft Word left out random contacts from the label sheets. It's not a fun process to go through thousands of contacts looking for missing people. In the tutorial video, I'll show you how to create mailing labels from your eEdge myContacts using Avery's Design & Print Online tool.
View Fullscreen HD
Avery, if you don't know, is the company most well-known for their labeling products. It makes sense that Avery would want to facilitate the process of printing with their products, given that it can be difficult task. Their online tool makes the process incredibly simple. If you've ever bought Avery labels or Office Depot's or Staples' store brand, you've probably purchased the 5160 labels, which is what I create in the tutorial video.

Keller Williams agents using eEdge's myContacts have the option to export their contacts into a CSV (comma-separated values) file. A CSV file is actually a text file with entries separated by commas (hence the name), that can be understood by and edited in spreadsheet applications such as Microsoft Excel and Apple Numbers. The great thing is, you don't even have to open or edit eEdge's CSV file in either of those applications. Just export the file from eEdge to your computer, then point Avery's Design & Print Online tool at it, and the tool will import all of your myContacts into individual mailing labels allowing you to change text typefaces, colors, sizes, add images, and even add various types of shape and barcodes.

As easy as the Avery Design & Print Online is to use, it's actually quite powerful, and much more highly recommended than trying to figure out Microsoft Word's arcane mail merge system.
Comments

    Author

    Wes Kennedy is the Technology Coordinator for Keller Williams Realty Elite in Oklahoma City. His job is to train and assist Keller Williams real estate agents in using technology to better help their business.

    Archives

    February 2016
    March 2015
    November 2014
    October 2014
    July 2014
    June 2014
    May 2014
    April 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012

    Categories

    All
    Apple
    Apple Mail
    Collaboration
    DotLoop/myTransactions
    Dropbox
    EAgentc
    EEdge
    EEdge Custom Page
    EEdge MyContacts
    EEdge MyContacts
    EEdge Websites
    Evernote
    Facebook
    Gmail
    Google
    Google Android
    Google Android
    Google Calendar
    Google Chrome
    Google Drive
    Google Picasa
    Images
    Internet
    IOS
    IOS 7
    IPad
    IPhone
    KW.com Agent Profile
    KW Email
    KW Email
    KWKLY
    KWLS
    KW Mobile App
    KW Whitepages Profile
    Mac OS X
    Mac OS X Mavericks
    Marketing
    Microsoft Excel
    Microsoft Internet Explorer
    Microsoft PowerPoint
    Microsoft Word
    Mozilla Firefox
    Mozilla Firefox
    MyKW
    PDF
    Photography
    Productivity
    Products
    Security
    SEO
    Smartphones
    Tablets
    Tech Tips
    Tech Tips
    Text-to-Lead
    Training
    Whitepages Profile
    Whitepages Profile
    Windows
    Windows 7
    Windows 8
    Zopim

Picture

KW REALTY ELITE, OKC

5629 N Classen Blvd
Oklahoma City, OK  73118
(405) 948-7500    office
(405) 948-7502    fax
License/Entity #113575

KW REALTY ELITE, YUKON

1029 E Vandament Ave
Yukon, OK  73099
(405) 354-4888    office
(405) 354-4885    fax
License/Entity #146371

CONTACT WES KENNEDY

(405) 463-6796    office
tech@kweliteokc.com