Solved

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

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

724 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