#HOW TO MAIL MERGE LABELS FROM EXCEL UPDATE#
#HOW TO MAIL MERGE LABELS FROM EXCEL CODE#
#HOW TO MAIL MERGE LABELS FROM EXCEL DOWNLOAD#

The second reason, which is less common, is that there is debris, such as a label that has come off the sheet, and has stuck to any one of the rollers or on the fuser assembly. This is the most common reason for jamming labels. This should prevent your labels from jamming, but it will also considerably slow down printing speeds depending on the model printer you have. If “labels” is not an option then just choose the thickest possible paper thickness. Paper thickness can also be shown as “Media Type” or “Paper Type”. To be able to print jam free, you need to set the paper thickness to “labels” in the printer preferences dialog box. The first reason, which you can verify pretty quickly, is that you are not using the proper paper thickness setting while printing. We would like to sincerely apologize for your experience with our product. Adjust your printer and design if necessary. 9 – PrintĪlways test printing on a plain white paper first, then holds up to the light against a sheet of labels to check that your design is roughly aligned.

You need to take this into account when you design your labels. Printers have an accuracy of approximately 1mm in the vertical and in the horizontal, and the paper can also rotate slightly as it goes through the printer.

#HOW TO MAIL MERGE LABELS FROM EXCEL UPDATE#

you need to close the “Mail Merge Word Document” first before making any changes to the MS Excel file.Īfter you make changes to the MS Excel file, then open the ““Mail Merge Word Document”, all records and fields will update automatic. While the “Mail Merge Word Document” is open, the related MS Excel file is not editable. and change the transparency value back to 0% befor printing. You can only apply one bleed design for all labels.ĭuring the design, to make the label’s outline visiable is important, we can do it by changing the shape’s background picture’s transparency value to 10%. You can do different bleed design for each labels.įor sheet label’s without enough spacing, for example MR321. 6 – Bleed Designīleed design is important if you want to make your labels look professional.įor sheet label Horizontal Spacing > 6 mm Vertical Spacing > 6 mm, for example MR860.

If the barcode type is not one of the list above, then we recommend to use TBarcode Add-Ins.īoth methods support Mail Merge Fields.

#HOW TO MAIL MERGE LABELS FROM EXCEL CODE#

We will recommend to use Word’s field code to generate barcode, no extra cost compared with other commercial Barcode Add-In. If the barcode type you plan to add is one of the followings: You can also edit them individually later.ĥ – Add Barcodes or QR codes from Mail Merge fields 4 – Add pictures and shapesĪdd pictures or shapes to the first label, then apply them to all the rest. Remember to save the previous “Mail Merge Word” document for future batch design. With help of the function “Edit Individual Documents”, you have the flexibility to make change for every individual label based on the previous batch design.Īfter you click the “Edit Individual Documents”, another Word document will be generated, and you will continue to work on this new file, 3 – Edit labels – First one for all, then one by oneĭesign the first label, then apply it to all the rest labels with one click. Mr-Label have already create the mail merge template, you don’t need to select the label type as showed in the video above. Now, the Word and Excel files have been linked.

Turn on the option ‘First row of data contains column headers’ You need to link the two files again following the procedures below.Ĭlick ‘Find Data Source’ in the dialog below, then select the ‘Sample Excel’ file in your computer.

#HOW TO MAIL MERGE LABELS FROM EXCEL DOWNLOAD#

When you download and save the ‘Mail Merge Word Template’ to your local computer, the link between the ‘Mail Merge Word Template’ and ‘Sample Excel’ will be invalid. First download the ‘Mail Merge Word Template’ together with the ‘Sample Excel file’.

How to mail merge labels from excel