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). 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. I can do this with a quick copy/paste from Coda, so not a big deal and pretty easy. Typically when I print labels, I pull the data down into an Excel spreadsheet and run a traditional mail merge to Word. So the challenge is to get the barcode + another field sent to this template in Word so I can print about 200 labels. It does not store any personal data.Screen Shot at 9.08.40 PM 2116×1446 250 KB The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. You can now either click Print to send the labels straight to a printer or click Edit individual labels to edit before printing. When you are happy with the layout of the first label click Update all labels. Space the fields out as required and add any other formatting needed (e.g. Repeat until all the fields that you want to include in the label have been inserted. You will see the field appear on the first label. Click OK on the Mail merge Recipients screen.Ĭlick More Items, highlight the field you want and click Insert. Now click Browse and point Word at the CSV file you created earlier from Pupil Asset. Avery A4/A5 from the Labels Vendors drop-down, then choose your label type (the label code can be found on the label packaging). Open MS Word and go to Mailings > Start Mail Merge > Step by Step Mail Merge WizardĬlick Label Options to choose the type of labels you are using. Select the data that you would like to see on the labels by clicking on Choose Columns.Įxport the data to CSV by clicking on the download button (right-hand side of red tool bar) and choose Download as CSV. Use the Filter Block to choose the pupils that you wish to print labels for. This guide is intended to support users through exporting data from Pupil Asset to use with a Microsoft Word mail merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |