Solved

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

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

786 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