Mail Merge With Spreadsheet And Labels
Import Data
Mail merge can be incredibly frustrating. It's an ancient computing term that no one understands. You could sit and watch hours of videos on how to setup mail merge with Word and Excel, but you'll still be shaking your head at how clumsy it feels. Often, you'll get it half working, only to realize the labels you're printing don't print correctly.
Lucky for you, Label LIVE makes mail merge very easy. Let's use a basic spreadsheet of addresses.
Download and open Label LIVE:
Click on the "Data" tab
Click "Import"
Choose your spreadsheet or CSV
Verify that your data rows look đź‘Ť
Setup Label Text
Next, you're going to add a Text object. This is where the address information will load. You do this using "variables." Variables are just a special way to insert the spreadsheet columns into your label.
Add Text object
Center the text on the label
Change Wrap to None and make the Text object as wide as the label
Set the anchor to be on center so the text always grows from the middle
Insert the data variables
Here's the text I used in the Text box:
{FIRST_NAME} {LAST_NAME}
{ADDRESS}
{CITY}, {STATE} {ZIP}Choose Label Output
Label LIVE can make labels in many different formats.
PDFs where every page is a label. This works for most label printers where the labels are on a roll.
PDFs where multiple labels are on the page. This works for sheets of labels compatible with inkjet and laser printers.
Images where every label is an image saved to your computer. Great for bulk submission to manufacturing processes.
Print each label directly to a supported thermal label printer. Excellent for performance and fine-tuning thermal printing.
Here's an example of a PDF where each label is a "page" in the PDF.
Here's another example of a PDF where a sheet contains multiple labels (Avery 5160).
With Label LIVE, you can easily configure your own sheets by measuring the page dimensions.
Sample Files
Download Today
Label LIVE is a great tool for modern mail merge. This example only uses text, but with Label LIVE, you can include images, barcodes, shapes, and serial number functionality. These features are just a few clicks away. Call me crazy, but Label LIVE makes mail merge ... fun!
