Solved

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

Posted on 2013-06-25
2
432 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

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…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
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…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

732 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