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.
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.
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.
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.
