I’ve built an inventory system for a client using the Barcode/QR pack (woohoo!), and I need to print those barcodes on some labels. The client has bought some Avery labels which come with a Word template:
So the challenge is to get the barcode + another field sent to this template in Word so I can print about 200 labels.
Typically when I print labels, I pull the data down into an Excel spreadsheet and run a traditional mail merge to Word. I can do this with a quick copy/paste from Coda, so not a big deal and pretty easy. (See below for update on this.) But I’d love to do this directly from the system if possible.
I understand this isn’t native, but I’m wondering if there are creative ideas for how to do this…
(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???)
Anyways, would appreciate thoughts or ideas…
And 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).
UPDATE: Doesn’t actually look like just pasting the data into Excel and running the mail merge like normal works after all. The bar code image pastes fine into Excel but doesn’t make it from Excel to Word.
This essentially renders the pack useless if I can’t actually print the labels…