findmypaster.blogg.se - Merge excel with word for labels

MERGE EXCEL WITH WORD FOR LABELS HOW TO
MERGE EXCEL WITH WORD FOR LABELS CODE

Press CTRL + F9 to open the curly brackets, type INCLUDEPICTURE and then a space.

Position the cursor in the first label cell:.

Click on “Select Recipients” in the toolbar ribbon and then “Use Existing List” and navigate to the Excel data source file created above.Ī dialog box will then appear – ensure that both “Sheet1” and “First row of data contains column headers” are both selected and press OK.

Choose the template you require and press OK, or if you have already opened your own downloaded digital template just press Cancel (don’t know why this step has to be done when using your own template, but it won’t work if you don’t)

Select “Start Mail Merge” and then “Labels”.

Any weird characters in the folder name or image names should be avoided as well – just stick to a-z and 0-9Įither open your digital template in MS Word (we downloaded our Avery 22805 label template from the Avery website) or use one of the templates pre-loaded into MS Word.

MERGE EXCEL WITH WORD FOR LABELS CODE

TIP: MS Word can be a bit fussy about file paths so it’s best not to have any spaces in name of the folder your QR codes are saved in, or in the names of the QR code images themselves. We used the label “qrcodes”.Ĭreate and save this spreadsheet for later use. This column also needs to have a field label in row 1 which will be used as a reference in the mail-merge process later on. The data source contains the path location on your computer for each of the indivdual QR codes images that will be displayed in each of the labels (24 in our case since we are creating 24 different stickers on a single sheet of labels). The simplest way is to create an MS Excel spreadsheet contining the image file paths for each QR code in column 1.

The mail-merge process intially requires a “data source” which should be prepared first. The point we’re assuming you’re currently at is that you’ve already created your QR code images and have saved them locally into a folder on your computer, and the end result of the instructions shown below will be a sheet of labels containing each of these previously created QR codes. We’ve used the Avery 22805 label template (1.5″ x 1.5″ 24 per sheet) but you can use any digital label template you want. Here’s some step-by-step instructions on using a label template in MS Word 2010 to create QR code sticker labels from a pre-made set of QR codes using the mail-merge function.

MERGE EXCEL WITH WORD FOR LABELS HOW TO

Posted: March 15th, 2014 | Author: admin | Filed under: General, Generating QR Codes, How To Make QR Code Labels & Stickers, How To Make QR Code Labels & Stickers, How To Make QR Code Labels & Stickers, QR Codes Use Cases | 1 Comment »