Solved

Word Label Mail Merge with QR Code is wrong on page 2+

Posted on 2013-06-25
2
430 Views
Last Modified: 2013-06-26
I have a Mail merge that is pulling data from an excel spreadsheet (sheet name:  Summary$)

I created the mail merge document inserting the fields I need from the worksheet.  One of the fields is called "Barcode".  I apply the fond "IDAutomation2D", and the QR encoded data is displayed as a bar code.  Problem is that at the end of page 1, the last row of labels and all subsequent pages have the bar code showing up very large and taking up the entire space on the label.  Why is it doing this and how can I fix this, so the bar code does what the 1st row on page 1 is doing?

See attached spreadsheet and word template and output.
Job.docx
TemplateNest.xls
TemplateNestBarcode.docx
0
Comment
Question by:ndornack
2 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 39277045
It might have something to do with your data. The first eight records have a length of 315 characters (Summary Tab - Column R). After that, the rest have 1139. I'm not familiar with  EncQR Function, but I noticed it's not in cells P2 to P9. I tried to copy P9 to P10 but received an error.

Flyster
0
 

Author Closing Comment

by:ndornack
ID: 39277714
Thanks.  That was the problem, the data had more characters on those other cells.  Once I copied the formula in row 2 to the rest, its working now.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question