Solved

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

Posted on 2013-06-25
2
429 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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