UPDATE: Doesn’t actually look like just pasting the data into Excel and running the mail merge like normal works after all. (Honestly, I’m not sure how useful the Barcode pack is without this functionality - what else are you supposed to do with barcodes, if not print them on stuff?)Īnyways, would appreciate thoughts or ideas…Īnd because I’m guessing this will come up - I know I can pull data into Google Docs, but Google doesn’t have mail merge functionality (or it requires an add-on, and the company I’m building this before has privacy concerns, so that’s not an option, merp).
Mail merge with avery labels how to#
I understand this isn’t native, but I’m wondering if there are creative ideas for how to do this… (See below for update on this.) But I’d love to do this directly from the system if possible. If you have used a saved label template, you will need to add in this rule yourself. 4) Merging the data with the main document label template. 3) Defining the Merge Fields in the label template. 2) Creating a data source from a spreadsheet or database. I can do this with a quick copy/paste from Coda, so not a big deal and pretty easy. It all starts with your mailing list The easy step-by-step process is as follows: 1) Downloading or creating a main document label template. Typically when I print labels, I pull the data down into an Excel spreadsheet and run a traditional mail merge to Word. Screen clip 1 below shows the line spacing being set up using the Table Grid style as I have always don in the past. I always use Avery 5262 labels with great results.until this year.
Hi Folks, I have been using Word for many years to print labels to be applied to envelopes. So the challenge is to get the barcode + another field sent to this template in Word so I can print about 200 labels. Word Mail Merge Address Block is Double Spaced on Labels.