Resolved Questions

JimV

Dimensions of Aztec barcode in Word after mail merge from Excel

Tagged With:-

Hi, I followed the Excel-to-Word mail merge tutorial to generate Aztec barcodes in a Word document. Everything is working but I need to make the dimensions of the resulting Aztec barcode in Word smaller to fit into a label. I tried setting the NarrowBarCM property of the MFontEncoder object in the Excel document to a smaller value but that seems to have no effect even after reloading the mail merge values in Word. Changing the size of the IDAutomation2D font in the Word document also appears to have no effect. Is there a way to shrink the Aztec barcode in the Word document or is it pretty much a case of it is what it is?

Operating System: Windows XP

Application: MS Excel 2010, MS Word 2010

08-09-13 10.5 year(s) ago

Report Abuse


Ben	Best Answer I do not believe it is the font. However, it does not hurt to reinstall. I think the issue might be coming from Word. Posted 10.5 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (5)

JimV	Ben you appear to be correct -- it's Word. It's working in Word 2003 but the barcode gets corrupt in Word 2010 on my machine when changing the font size. Looking into the Word 2010 installation for the solution. Posted 10.5 year(s) ago (0) (0) Report Abuse

JimV	Will do that, thanks! Posted 10.5 year(s) ago (0) (0) Report Abuse

Ben	As a test, I performed a mail merge using the data 1234567890 and set the font to various sizes. If you would like to send your Excel and Word files to us: Contact Us, I can take a look at them as I am not able to reproduce the issue. Posted 10.5 year(s) ago (0) (0) Report Abuse

JimV

Thanks for the reply! I followed the Excel tutorial, so there's a column in an Excel spreadsheet containing the values to encode, a second column in the spreadsheet using the "=EncAztec" formula on the cell in the first column, and then the Word document uses the spreadsheet as the data source for the mail merge. The barcode field uses the Windows IDAutomation2D barcode font. In Excel, I tried modifying the EncAztec VBA code to change the NarrowBarCM attribute of the Aztec object that the code uses, hoping it might change the encoded string (though I don't think it actually does). In Word, I tried changing the size of the IDAutomation2D font that's applied to the barcode field. Neither attempt had any discernible effect on the barcode size.

Posted 10.5 year(s) ago

(0)

Report Abuse

Ben	What font encoder are you using to encode the data? There should not be a NarrowBarCM option unless you are using an ActiveX Control to generate a graphic. If you are using a font encoder, the NarrorBarCM/XDimension is controlled by the font size. Posted 10.5 year(s) ago (0) (0) Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must starts with "http://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always starts with " http:// ")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 Characters are allowed. Current Count: 0

Your comment on this answer

Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must start with "http://" or "https://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always start with "http://" or "https://")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 characters are allowed. Current Count: 0

My Profile

You may answer and comment on any thread according to the Terms and Conditions.