Home

TBarCode Office User Manual V10.7

1. Value Description Both Hardware and Software Select this option if you do not know which type of barcode decoder will be used Based on the adjusted resolution see section 7 3 3 4 TBarCode OCX will automati cally choose a barcode size which can be read with both decoder types Software and Hardware gt If you are unsure about the resolution we recommend a setting of 200 dpi This should be readable in most cases Hardware Select this option if the barcode is scanned and decoded via a scanning device e g handheld scanner This setting guarantees a minimal module width of 0 254 mm for linear barcodes and 0 5 mm for 2D barcodes Software Select this option if the barcode symbol is received as an image e g via flat bed scanner camera fax software etc and decoded via software solution This setting guarantees a minimal module width of 5 pixels This value ensures reada bility by most software decoders TBarCode InForm Select this option if you plan to use the upcoming TBarCode software solution for decoding the barcode symbol Table 13 Decoder 7 3 4 Display Error if Barcode is clipped For certain configurations it is possible that the barcode grows bigger than the bounding rectangle In this case all bars which extend the size of the bounding rectangle are clipped by default To make sure that the barcode does not remain unreadable because of clipped regions you can check the
2. Module Width auto Width 79 904 Height 40 Insert Barcode m a 1 Page1of1 Line 1 Owords EZ German Austria 1 EA Figure 2 TBarCode Office User Interface in Word 5 12 TBarCode Office Panel In the TBarCode Office panel you make all your adjustments for the barcode to be encoded Options Description 0 Opens a list of barcode templates With these pre defined settings it is easy to generate barcodes which comply with common barcode standards The settings from the template are applied to the barcode See section 5 3 1 Templates Barcode Select the barcode type from the menu list Data Enter the data for the barcode in the field Barcode Data Insert Field The button nsert Field allows you to insert mail merge fields and document properties into the barcode data For mail merge fields see section 6 2 Size Adjust the appearance of the barcode by using the fields Module Width Width and Height By clicking on the measure unit next to Size in you can toggle between millimeters and mils a mil is one thousandth of an inch 0 0254 millimeters Barcode Settings Barcode Settings is used for adjusting additional parameters like bar width reduction or font and color settings For further information see chapter 7 WWW TEC IT COM Page 9 of 60 Insert Barcode The button nsert Barcode inserts a barcode at the required cursor pos
3. General Orientation I Print ratio V Default Back style Transparent w Bar width reduction jo 00 IV Default Bearer bars None Bearer bar width 1 1000 mml IV Defa 1 2 3 4 1 2 3 4 Draw mode Default Quiet zone Adjust Text options V Print text Above symbol Alignment Default w Text distance 1 1000 mm V Default Barcode size and module width Mode Default Fit to bounding rectangle Module width 1 1000 mm l Resolution 300 dpi Poor print quality Custom resolution dpi 300 0 Display error if barcode is clipped Hardware decoder Decoder Figure 15 Property Page Appearance 7 3 1 General 7 3 1 1 Orientation Specifies the orientation of the barcode Selectable values are 0 90 180 and 270 The barcode is rotated counter clockwise gt Please note Some fonts for the human readable text do not support rotation e g some bitmap fonts If rotation is required we recommend selecting a TrueT ype font 7 3 1 2 Print Ratio The print ratio is the relationship between the bar widths and the space widths of a barcode Another term for print ratio is bar width ratio or bar space width ratio gt By default there is no need to change the print ratio unless needed for any special appli cation Please consider Barcodes may become unreadable when manipulating this value
4. Table 20 QR Code Error Correction Levels WWW TEC IT COM Page 49 of 60 7 13 4 Mask Pattern Selects the mask pattern which is applied to the barcode symbol XOR masking The goal of the mask pattern is to distribute the bar space transitions evenly over the symbol in order to improve the readability of the barcode Value Description Default Selects the mask pattern automatically recommended 0 7 Selects one of the mask patterns 0 to 7 manually Manual selection may be useful if you want to generate many symbols within minimal computa tion time The algorithm for identifying the optimal mask automatically is complex and resource consuming However the readability of the barcode may suffer when using manual selection Table 21 QR Code Mask Patterns 7 13 5 Compaction QR Code can compact dedicated Multi Byte character sets from 16 bit representation into 13 bit en coding This property enables the compaction of Kanji or Simplified Chinese characters into 13 bit values ActiveX controls are using the Unicode character set Depending on the Code Page property the Unicode input is converted to the corresponding encoding If you use one of the available compaction modes please make sure that the Unicode input is converted to either Shift JIS X 0208 Kanji or GB2312 Simplified Chinese Also make sure that your decoder scanner can deal with these compaction modes Value Description
5. 72 720 77 Email mailto support tec it com Web http www tec it com AIX is a registered trademark of IBM Corporation HTML DHTML XML XHTML are trademarks or registered trademarks of W3C World Wide Web Consortium Laboratory for Computer Science NE43 358 Massachusetts Institute of Technology 545 Technology Square Cambridge MA 02139 JAVA is a registered trademark of Sun Microsystems Inc 901 San Antonio Road Palo Alto CA 94303 USA JAVASCRIPT is a registered trademark of Sun Microsystems Inc used under license for technology invented and implemented by Netscape Microsoft Windows Microsoft Word Microsoft Excel are registered trademarks of Microsoft Corporation Navision is a registered trademark of Microsoft Business Solutions ApS in the United States and or other countries Oracle is a registered trademark of Oracle Corporation PCL is a registered trademark of the Hewlett Packard Company PostScript is a registered trademark of Adobe Systems Inc SAP SAP Logo R 2 R 3 ABAP and SAPscript are trademarks or registered trademarks of SAP AG in Germany and in several other countries Unicode is a trademark of Unicode Inc All other products mentioned are trademarks or registered trademarks of their respective companies If any trademark on our web site or in this document is not marked as trademark or registered trademark we ask you to send us a short message mailto office tec it com WWW TEC I
6. The print ratio must be specified in a specific format This format depends on the number of different bar and space widths used in the selected symbology Example If a barcode element has 4 different bar widths and 4 different space widths the print ratio looks like this Code 128 1 2 3 4 1 2 3 4 In the first part 1 2 3 4 the width ratio of the bars is set in the second part the relation of the spaces is set in our case they are the same The small est bar is 1 wide the next larger is 2 wide thus twice as wide as the smaller bar and so on For more information on print ratios please refer to the Barcode Reference see Appendix A 7 3 1 3 Back Style The barcode can be painted with transparent background default background shines through or with opaque background background is drawn in the adjusted color WWW TEC IT COM Page 30 of 60 gt If the back style is set to Transparent the adjusted background color will be ignored 7 3 1 4 Bar Width Reduction Sets the bar width reduction in percent When printing on inkjet printers the ink that is absorbed by the paper tends to diffuse Setting the bar width reduction allows you to work against this spreading of ink But also for laser printers with high toner saturation this property is useful The bar width reduction can be specified in percent of the module width Thus when set to 20 all bars will be narrowed by 20 percent of the modul
7. 7 13 6 3 Number of all Symbols 2 16 Enter the total number of chained QR Code symbols here A maximum of 16 symbols may be used within one chain 7 13 6 4 Index of this Symbol 1 16 A symbol identification number which is entered in the index field must be assigned to each QR Code symbol Its value can range from 1 to 16 This index indicates the order in which the data is joined after the reading scanning process WWW TEC IT COM Page 51 of 60 7 14 Adjust Properties Micro QR Code The Micro QR Code is a small variant of the QR Code with a reduced number of overhead modules and a restricted range of sizes The maximum amount of data is 35 numeric 21 alphanumeric 15 byte or 9 Kanji characters in conjunction with the lowest error correction level QR Code Properties i n General Format application indicator ote 2 digits 1 char Symbol version size bd Error correction level Medium Mask pattern Dear Compaction Deu Structured append Parity byte 0 255 Number of all symbols 2 16 Index of this symbol 1 16 Cancel Figure 27 Advanced Properties Micro QR Code 7 14 1 Symbol Version Size The Micro QR Code has four different symbol sizes M1 M4 The smallest version size M1 is restricted to numeric data and error detection M2 may contain alphanumeric values M3 and M4 may use the whole range of the QR Code character sets bytes Kanji 7 14 2 Erro
8. Aztec Runes can be displayed in a very compact way and are highly readable due to Reed Solomon error correction WWW TEC IT COM Page 39 of 60 7 8 5 Error Correction in 0 90 Unlike other barcode types the error correction level of an Aztec Code is not described in pre defined levels but can be specified in percent of the data amount Default error correction level is 23 which is recommended but it may be in the range from 0 up to 90 7 8 6 Structured Append If you want to connect several Data Matrix symbols in order to encode larger quantities of data you can use Structured Append 7 8 6 1 Use structured append Activates structured append symbol chaining with this option 7 8 6 2 Number of all symbols A Z Enter the total number of chained Data Matrix symbols here A maximum of 26 symbols may be used within one chain where A stands for 1 and Z stands for 26 7 8 6 3 Index of this symbol 1 16 A symbol identification number which is entered in the index field must be assigned to each Data Matrix symbol Its value can range from A 1 to Z 26 This index indicates the order in which the data is joined after the reading scanning process 7 8 6 4 Message ID The Message ID has to be the same for all symbols within a chain WWW TEC IT COM Page 40 of 60 7 9 Adjust Properties Codablock F Codablock F is a stacked symbology like PDF417 based upon the Code 128
9. Default Default multi byte character compression Depends on specified Code Page None No multi byte character compression Kanji compaction Enables Kanji character compaction Input data must be supplied in Multi Byte character set Shift JIS X 0208 see Code Page Compaction of Kanji characters is done according to ISO IEC 18004 and AIM ITS 97 001 specification Chinese compaction Enables Chinese character compaction Input data must be supplied in Multi Byte character set GB2312 see Code Page Compaction of Chinese characters is done according to GB T 18284 2000 Please note that this compaction mode is not supported by all decoders Table 22 QR Code Compaction Modes 7 13 6 Structured Append If you want to connect several QR Code symbols for encoding larger quantities of data you can use structured append 7 13 6 1 Use Structured Append Activates structured append symbol chaining 7 13 6 2 Parity Byte 0 255 Chained QR Code symbols are identified by the parity byte The parity byte must be identical in all symbols of a chain gt The value of the parity byte depends on the barcode data for the complete chain To calcu late its value you can use the method QRCode StructAppParity which is available in the ActiveX interface For more information about the ActiveX interface and its available methods please refer to the developer manual see Appendix A WWW TEC IT COM Page 50 of 60
10. 7 12 2 1 Mode Specifies how data is encoded when using Micro PDF417 In most cases the Default or the Binary mode is the best choice Some decoders may not support all modes listed here Please check with your scanner first Value Description Normal Default Analyzes the input data Depending on the input data either text numeric or binary compaction mode is used in order to keep the resulting symbol as small as possible UCC EAN 128 Emulation UCC EAN 128 emulation mode Transmit C1 or L3 Use compaction for Application Identifier Al 01 14 digits Code128 Emulation Code 128 emulation mode Transmit C2 or L4 Code128 FNC2 Emulation Code 128 with FNC2 on first position will be emulated Linked UCC EAN 128 Linked UCC EAN 128 emulation Transmit JC1 or L3 This mode links the MicroPDF symbol with a linear 1D symbol The linked symbol may be required for a successful scan The symbol can be encoded with better compaction when using one of the following orders for Application Identifiers Als date Al 11 13 15 or 17 lot number Al 10 other Als optional date Al 11 13 15 or 17 serial number Al 21 other Als optional date Al 11 13 15 or 17 other Als optional Note This mode is not used with GS1 Composite Symbology which uses linked symbols as well 05 Macro The preamble gt RS 0 5 GS precedes the barcode data 06 Macr
11. Color Properties Color Set m BackColor Standard Colors Color Palette ForeColor 0O TextColor White Edit Custom Color ee ea EA EE Figure 19 Property Page Color In order to change the color for one of the barcode components background foreground human readable text you have to select the corresponding property in first Then click on the desired color in gt Please note The color in will only be updated when switching between the list entries 7 6 1 Properties Select the property that you want to change BackColor The background color of the barcode color of the spaces If the back style is set to Transparent the adjusted background color will be ignored ForeColor The foreground color of the barcode color of the bars TextColor The color of the human readable text 7 6 2 Color Set You can choose between Standard Colors and Windows System Colors Each of these color sets offers a different color palette 7 6 3 Color Palette Clicking on one of the list entries assigns the color to the selected property 7 6 4 Edit Custom Color Clicking this button opens a dialog which lets you select a color for the list entry lt Custom gt Alternatively you can also double click on the lt Custom gt list entry WWW TEC IT COM Page 37 of 60 7 7 Adjust Depending on the selected barcode type TBarCode offers additiona
12. Office uses the Microsoft ActiveX compliant barcode component TBarCode OCX which is installed automatically as part of the setup This component can be used by VBA programmers as well however if your focus lies on VBA or Access programming you should use TBarCode SDK instead 3 2 Scope of this Document This document concentrates on the use of TBarCode Office The first part of this document explains how to insert barcodes in normal documents and spreadsheets as well as in mailings or serial letters The integration of barcodes by using the mailings feature is explained with an example Then we concentrate on the user interface of the TBarCode Office Add In For this we introduce the TBarCode Office panel for Word and Excel in detail The second part of this document describes all available barcode properties which can be adjusted in the property dialog 33 Restrictions of the Demo Version In the demo version the barcodes will be drawn with a demo hint That means that the word Demo or the phrase www tec it com is drawn partially over the barcode In most cases the demo hint does not influence the readability of the barcode in a negative way gt In special cases very small or high resolution barcodes you may want to test the product without restrictions To obtain a free temporary license key contact sales tec it com gt For enabling the full featured version without the demo hints you can obtain a license k
13. character set Each row consists of a Code 128 symbol but extended with row indicators row count and sequence number and an additional check digit CODABLOCK F Properties ml Rows 2 44 V Default Columns 4 62 V Default Row height 1 1000 mm V Default Separator height 1 1000 mm V Default Code format Default bd Cancel Figure 22 Advanced Properties Codablock F 7 9 1 Rows 2 44 Specifies the number of rows used for encoding The value must be between 2 and 44 Default the number of lines is calculated automatically depending on the number of input characters 7 9 2 Columns 4 62 Defines the number of columns of the generated bar code The value must be between 4 and 62 Start stop and line indicator columns as well as code subset selectors are not taken into account Default the number of columns is calculated automatically depending on the number of input characters 7 9 3 Row height 1 1000 mm Sets the height of an individual row in 1 1000 mm Default The row height is calculated automati cally 7 9 4 Separator height 1 1000 mm Sets the height of the row separator in 1 1000 mm Default The height of the separator is calcu lated automatically 7 9 5 Code format You can choose one of the following formats Value Description Default Standard format UCC EAN GS1 Special format defined by GS1 UCC EAN to be used in GS1 applications Used for encodin
14. default or for all users If you want to install the add in for all users please enable this option in the setup dialog J TEC IT TBarCode Office 10 Setup Ready to install TEC IT TBarCode Office 10 Click Install to begin the installation Click Back to review or change any of your installation settings Click Cancel to exit the wizard oO Add In for All Users requires Office 2010 for Office 2007 see KB976811 NS Figure 1 Register Add In for All Users 2 The number of bar codes and bar code operations insert redraw are limited by system resource consumption 3 Users will need to install MSXMLS if not already present The VSTO 4 0 Runtime is included in the TBarCode Office setup WWW TEC IT COM Page 8 of 60 5 User Interface This chapter will give you an overview of the TBarCode Office user interface 5 1 TBarCode Office for Microsoft Word 5 1 1 Activating the Barcode Panel To activate or open the task pane switch to the Add Ins tab and then click on the panel button The TBarCode Office panel appears immediately on the right side of the document Documentl Word O0 x Home Insert Design Layout References Mailings Review View Add Ins D T o Signin Share Eu Ej insert Barcode IES Eg TEC TT Website TBarCode Panel Ed Help Barcode a TBarCode Office es Barcode Code 128 7 Data 1234567890 Insert Fields 1234567890 Size Fit into Bounding Box 7
15. more sensitive regarding resource consumption Mail merge into a new document Mail merge with labels multiple bar codes per page Workarounds If you have a higher number of bar codes to be generated split up bar code generation into multiple Word sessions mail merge operations A mail merge directly to the printer consumes less resources than into a new document Disabling the human readable text in the bar code will use less GDI resources For large mailings mass printing we offer TFORMer our label form printing software 6 2 6 Known Issues Word Add In Please take care of the following known issues when using the Word Add In Using the NextRecordlf field in a mail merge document can result in a wrong out of sync record number in the progress bar and in the error log Encoding the left and right angle quotes into a bar code in a mail merge document is only possible with escape sequences It is not possible to insert a bar code directly into a Field because the bar code object will be deleted by Word after the field update Additionally if the bar code data contains a mail merge field an error message will be displayed Mail merges with text file data sources e g TXT CSV are supported only with an OLE DB data connection If accessed directly without OLE DB driver only the first two records can be merged then the mail merge stops Mail merge to printer stops if Microsoft Office Out
16. new Excel workbook Click inside the worksheet and type some data into a cell Open the panel see 5 1 Click on an empty cell and click Insert Barcode Click Link to Cell The button text will change to Select a Cell ESC to Abort Click on the cell that was created in step 2 6 3 1 2 Automatic Linking Start with a new Excel workbook Click inside the worksheet and type some data into a cell Open the panel see 5 1 Check Automatically Link to Cell Select the cell Click Insert Barcode Bookl Excel m Home Insert Page Layout Formulas Data Review View Developer Add Ins Y Sign in 2 Share aat Ef insert Barcode E3 Ed TECIT Website TBarCode Panel a Help Barcode a c2 fe 1234567890 v A B c D E F o TBarCode Office x Barcode Code 128 67890 1234567890 1234567890 Link to Cell 3 Size Fit to Selected Cell 2 Module Width 0 905 4 Width 81 492 Height 22 490 Size in mm X 5 i 2 E Automatically Link to Cell m Insert Barcode Sheetl 4 gt X Ready 7 BE mm H 100 Figure 12 Link Barcode WWW TEC IT COM Page 22 of 60 Generate Barcode Lists 6 3 2 To create a list of bar codes based on the cell contents follow the steps below 6 3 2 1 General Guide for Creating Barcode Lists Start with a new Excel workbook Click inside the worksheet and type some data int
17. not depends on your application and on the selected barcode type By default the appropriate check digit is selected automatically entry Default which means that the check digit is calculated according to the barcode specification Any other suitable calculation method can be selected via the combo box Why check digits In order to guarantee that the barcode data is read properly a check digit is inserted usually at the end of the utilizable data A comparison of the barcode content and the check digit informs the scanning device about the correctness of the scan It causes the device to accept or to reject repeat the scan The check digit calculation method is standardized for certain common barcodes gt A different check digit method is admissible for special applications or for bar code types with selectable check digit methods only gt For some barcodes the default is to use no check digit However using a check digit may be recommended depending on bar code type e g LOGMARS or Code39 You can use the combo box for enabling check digit calculation gt Often modern symbologies have already a built in check digit e g Code 128 7 2 7 1 Check Digit Calculation Some barcodes with a predefined number of utilizable data characters like EAN 13 UPC A and GS1 DataBar include a check digit on a fixed position in the barcode data Example The EAN13 code permits 12 utilizable digits plus 1 check dig
18. 6 2 5 1 System Resources 20 6 2 6 Known Issues Word Add In 20 6 3 Microsoft Excel 22 6 3 1 Link a Cell with a Barcode 22 6 3 1 1 Manual Linking 22 6 3 1 2 Automatic Linking 22 6 3 2 Generate Barcode Lists 23 6 3 2 1 General Guide for Creating Barcode Lists 23 6 3 3 Updating Barcode Controls 23 6 3 4 Interferences with VBA 23 6 3 5 Limitations Excel Add In 24 6 3 5 1 System Resources 24 6 3 6 Known Issues Excel Add In 24 6 3 6 1 Resizing Issues 24 7 Barcode Settings 26 7 1 Introduction 26 7 2 Property Page Barcode 26 7 2 1 Barcode Type Symbology 26 7 2 2 Button Adjust 26 7 2 3 Barcode Data 27 7 2 4 Encoding Mode 27 7 2 5 Code page 27 7 2 6 Format Subset 27 7 2 7 Check Digit 28 7 2 7 1 Check Digit Calculation 28 7 2 8 Compression 28 WWW TEC IT COM Page 2 of 60 7 2 9 Suppress Error Messages 7 2 10 Translate Escape Sequences 7 2 11 Button License 7 2 12 Button About 7 3 Property Page Appearance 7 3 1 General 7 3 1 1 Orientation 7 3 1 2 Print Ratio 7 3 1 3 Back Style 7 3 1 4 Bar Width Reduction 7 3 1 5 Bearer Bars 7 3 1 6 Bearer Bar Width 1 1000 mm 7 3 1 7 Draw Mode 7 3 1 8 Quiet Zone 7 3 2 Text Options 7 3 2 1 Print Text 7 3 2 2 Above Symbol 7 3 2 3 Alignment 7 3 2 4 Text Distance 7 3 3 Barcode Size and Module Width 7 3 3 1 Mode 7 3 3 2 Module Width 1 1000 mm 7 3 3 3 Resolution 7 3 3 4 Custom Resolution DPI 7 3 3 5 Decoder 7 3 4 Display Error if Barcode i
19. 8 Name Title Name Name john Doe Name Tag tagName Data Show as Bounding Box s Color tagNamel Use a style to format text typed into the empty control tyle Default Paragraph Font ort Field Remove content control when contents are edited Fit into Bounding Box v John Doe Locking Y Content control cannot be deleted Module Width Figure 11 Reference Content Controls Please use the following placeholder format in the Barcode Data field TagName for Content Controls Bookmark for Form Fields and Bookmarks Please note that the referenced tag name or bookmark is case sensitive gt If the reference is unknown or the placeholder format is incorrect the unresolved place holder sequence will be encoded instead of the referenced value The following types of content controls and form fields are supported Content Controls Text Legacy Form Fields Text Rich Text Check Box Combo Box Drop Down Date Drop Down List gt The Word function Save amp Send does not refresh referenced values in the bar codes gt You can turn off referencing content controls form fields in the add in options 11 This is by design of Word there is no event raised where we can update the bar code controls 12 Support for referencing content controls and legacy form fields has been added in version 10 6 0 for bookmarks in 10 7 0 13 This behavior may be changed or made be con
20. Custom Specify module width this input box lets you specify the size of one module in 1 1000 mm A module is the smallest element of a barcode The widths of all bars and spaces are multiples of one module width Sometimes the Module Width is also called Narrow Bar Width A constant module width is recommended if you have a varying amount of input data and if the optical data density should remain constant Furthermore some label specifications require a cons tant module width gt Please note When specifying a custom module width the barcode may grow bigger than the bounding rectangle for big module widths or for a large amount of input data Please make sure that the bounding rectangle is wide enough to display the whole barcode symbol To ensure that no regions of the barcode are clipped you can enable the option Display error if barcode is clipped see section 7 3 4 7 3 3 3 Resolution The size mode Minimal Optimize for readability requires the Resolution of the printer scanner to be selected As value select the lowest resolution which is used within the chain of barcode processing printing scanning Additionally you have to select the decoding solution from the Decoder combo box below So it can be guaranteed that the printed barcode will be readable for the selected configuration WWW TEC IT COM Page 33 of 60 Examples If the barcode is printed w
21. Interface in Word Figure 3 Options Word Add In Figure 4 TBarCode Office User Interface in Excel Figure 5 Options Excel Add In Figure 6 Templates complying with various barcode standards Figure 7 Guide for Using Mailings Figure 8 Barcode Label Printing Figure 9 Barcode Label Printing Figure 10 Insert Document Properties Figure 11 Reference Content Controls WWW TEC IT COM 10 11 12 13 15 16 17 18 19 Page 4 of 60 Figure 12 Link Barcode 22 Figure 13 Guide for Creating Barcode Lists 23 Figure 14 Property Page Barcode 26 Figure 15 Property Page Appearance 30 Figure 16 Quiet Zone Adjustment 32 Figure 17 Property Page Multiple Barcodes 35 Figure 18 Property Page Font 36 Figure 19 Property Page Color 37 Figure 20 Adjust 38 Figure 21 Advanced Properties Aztec Code 39 Figure 22 Advanced Properties Codablock F 41 Figure 23 Advanced Properties Data Matrix 42 Figure 24 Advanced Properties MaxiCode 44 Figure 25 Advanced Properties PDF417 46 Figure 26 Advanced Properties QR Code 49 Figure 27 Advanced Properties Micro QR Code 52 Figure 28 Advanced Properties Composite RSS 53 Figure 29 License Dialog Online Activation 55 Figure 30 License Dialog Manual Licensing 56 1 2 List of Tables Table 1 TBarCode Office Panel in Word 10 Table 2 General Options Word Add In 10 Table 3 Mail Merge Options Word Add In 11 Table 4 TBarCode Office Panel in Excel 12
22. OM Page 45 of 60 7 12 Adjust Properties PDF417 PDF417 divides data content into graphical rows and columns It is a so called stacked symbolo gy This property page allows you to change specific settings for PDF417 PDF417 Truncated and MicroPDF symbologies PDF417 Properties EEE Lux en TTV Default Row height 1 1000 mm IV Defaut Columns 1 30 sd V Default Error correction level Defaut gt Encoding Mode Defaut gt MicroPDF 417 Mode Default v Version Default auto select Macro PDF 417 structured append Use Macro PDF417 L Segment index 7 File ID alphanumeric EE ERG File name TT A Segment count 1 99999 V De Time stamp TF IV De Sender TT EE Addressee VE rd File size TT RM Checksum CCITT 16 IT F De Cancel Figure 25 Advanced Properties PDF417 gt Please take care when modifying these properties Some settings may result in unreadable barcodes Always make a test scan in case of doubt 7 12 1 PDF417 These settings apply for all PDF417 based barcodes PDF417 PDF417 Truncated and MicroPDF417 7 12 1 1 Rows 3 90 Specifies the number of rows of one PDF417 symbol Values between 3 and 90 are allowed Default the number of lines rows is calculated automatically depending on the amount of input data 7 12 1 2 Row height 1 1000 mm Sets the height of an individual row in 1 1000 mm Default the row height is calculated automatically d
23. Properties Is General Format application indicator X 2 digits 1 char Symbol version size Default v Error correction level Medium A Mask patter Default z Compaction Default z Structured append Use structured append u Parity byte 0 0 255 Number of all symbols 2 16 2 Index of this symbol 1 16 1 Figure 26 Advanced Properties QR Code 7 13 1 Format Application Indicator You can choose from Value Description Default The standard format of QR Code UCC EAN GS1 Special format defined by GS1 UCC EAN Used for encoding so called Application Identifiers FNC1 is added at first position Industry For special industry formats If you choose this value you have to fill in an Application Indicator 2 digits or 1 letter It determines which industry format the barcode data corresponds to FNC1 is inserted at second position Table 19 QR Code Formats 7 13 2 Symbol Version Size Defines the version size of the QR Code symbol Possible values range from 1 21 x 21 to 40 177 x 177 modules If the property is set to default the size is computed automatically based on the length of the barcode data 7 13 3 Error Correction Level Defines the error correction level Value Description L ow Lowest level Data recovery capacity is approximately up to 7 M edium Up to 15 Q uartil Up to 25 H igh Highest level Up to 30
24. T COM Page 57 of 60 Appendix A Related Downloads A 1 For Software Developers For software developers the bar code control from the Office Add In is available as VBA programmable Barcode ActiveX Control see our product TBarCode SDK A 2 Barcode Reference The document Barcode Reference provides an overview over supported barcode types and gives additional information on how to use them The following issues are discussed Supported Barcode Symbologies with detailed information on each barcode type Check Digits general information and available check digits methods Print Ratio and Ratio Hints or Ratio Format Format Strings Escape Sequences and Control Characters Application Identifiers MaxiCode and UPS standards And more The Barcode Reference is available as separate document on the TEC IT web site http www tec it com gt Support Knowledge Base The direct URL is as follows http www tec it com download PDF Barcode Reference EN pdf WWW TEC IT COM Page 58 of 60 Appendix B TBarCode INI File For TBarCode you can specify an ini file which allows you to do the following tasks Preset the Draw Mode to Compatible Apply a Site Lock OCX only License TBarCode First create a text file named barcode ini and put the file in the same directory where the TBar Code dll and the TBarCode ocx are located This is usually the directory C Program Files Common File
25. Table 5 Option Settings Excel Add In 13 Table 6 Compression 27 Table 7 Compression 28 Table 8 Bearer Bars 31 Table 9 Draw Mode 31 Table 10 Text Alignment 33 Table 11 Size Mode 33 Table 12 Resolution 34 Table 13 Decoder 34 Table 14 Codablock F Code Formats 41 Table 15 Data Matrix Code Formats 42 Table 16 MaxiCode Compaction Modes 44 Table 17 PDF417 Error Correction Levels 47 Table 18 Micro PDF417 Compaction Modes 48 Table 19 QR Code Formats 49 Table 20 QR Code Error Correction Levels 49 Table 21 QR Code Mask Patterns 50 Table 22 QR Code Compaction Modes 50 Table 23 Composite Component Format 53 WWW TEC IT COM Page 5 of 60 2 Disclaimer The actual version of this product document is available as is TEC IT declines all warranties which go beyond applicable rights The licensee or reader bears all risks that might take place during the use of the system the documentation TEC IT and its contractual partner cannot be penalized for direct and indirect damages or losses this includes non restrictive damages through loss of revenues constriction in the exercise of business loss of business information or any kind of commercial loss which is caused by use or inability to use the product documentation although the possibility of such damage was pointed out by TEC IT E gt We reserve all rights to this document and the information contained therein Reproduction use or disclosure to third parties withou
26. UX and MAC of the target computer You can find the System ID or hostname in the licensing dialog of Barcode Studio see below a Licensing Please enter your license information System ID 44069255 Product TBarCode Office 2D 1D 2D Codes v Licensee Kind of License Number of Licenses Workstation Your License Key Figure 30 License Dialog Manual Licensing Perform the following steps to enter the license data 1 On the top of the dialog you find the System ID of your computer 2 For field Product please choose between TBarCode Office 1D Linear Codes and TBarCode Office 2D 1D 2D Codes 3 Inthe field Licensee enter the name of the license holder 4 Infield Kind of License please select the kind of license that you have purchased You can choose among Single Site Enterprise 5 The field Number of Licenses should be filled with the number of licenses that you purchased 6 Inthe field Your License Key enter the license key exactly as received from TEC IT 7 Confirm the dialog with OK 22 On UNIX Linux or Mac OS X the hostname of the system is used as System ID relevant only for Single licenses WWW TEC IT COM Page 56 of 60 9 Contact and Support Information TEC IT Datenverarbeitung GmbH Address Hans Wagner Str 6 AT 4400 Steyr Austria Europe Phone 43 0 7252 72 720 Fax 43 0 7252
27. WWW TEC IT COM TBarCode Office Barcode Add In for Microsoft Office Version 10 7 User Manual 28 October 2015 TEC IT Datenverarbeitung GmbH Hans Wagner Str 6 A 4400 Steyr Austria t 43 0 7252 72720 f 4443 0 7252 72720 77 office tec it com http www tec it com 1 Content 1 Content 2 1 1 List of Figures 4 1 2 List of Tables 5 2 Disclaimer 6 3 Introduction 7 3 1 What is TBarCode Office 7 3 2 Scope of this Document 7 3 3 Restrictions of the Demo Version 7 4 Installation 8 4 1 Requirements 8 4 1 1 Dependencies 8 4 2 Download and Setup 8 5 User Interface 9 5 1 TBarCode Office for Microsoft Word 9 5 1 1 Activating the Barcode Panel 9 5 1 2 TBarCode Office Panel 9 5 1 3 Options 10 5 2 TBarCode Office for Microsoft Excel 11 5 2 1 Activating the Barcode Panel 11 5 2 2 TBarCode Office Panel 12 5 2 3 Options 12 5 3 User Interface Common for Word and Excel 13 5 3 1 Templates 13 6 Using TBarCode Office 14 6 1 Operations Common for Word and Excel 14 6 1 1 Inserting a Barcode 14 6 1 1 1 Using the Insert Button 14 6 1 1 2 Using the Insert Tab 14 6 1 1 3 Using the Add Ins Tab 14 6 1 2 Updating a Barcode 14 6 1 3 Deleting a Barcode 14 6 1 4 Loading a Template 14 6 2 Microsoft Word 15 6 2 1 Create Mailings 15 6 2 2 Create Labels 16 6 2 2 1 Resulting Labels 17 6 2 3 Insert Document Properties 18 6 2 4 Reference Content Controls Legacy Form Fields and Bookmarks 19 6 2 5 Limitations Word Add In 20
28. adable text Table 10 Text Alignment 7 3 2 4 Text Distance Allows you to specify the distance between the human readable text and the barcode in 1 1000 mm If Default is marked the minimum text distance is used Otherwise the given value will be added 7 3 3 Barcode Size and Module Width 7 3 3 1 Mode This option selects the calculation method for the barcode size Value Description Default Fit to bounding rectangle Draws the biggest possible barcode which fits into the bounding rectangle Resizing the bounding rectangle directly resizes the barcode Custom Specify module width Uses the specified module width for drawing the barcode see section 7 3 3 2 Minimal Optimize for readability Creates the smallest possible barcode for the selected Resolution see section 7 3 3 3 and for the selected Decoder type see section 7 3 3 5 Furthermore the module width of the barcode will be optimized for ensuring best readability Table 11 Size Mode gt Please note The size modes Custom and Minimal influence the horizontal size of a barcode only The barcode height is always given by the height of its bounding rectangle Only a few 2D barcodes like Data Matrix QR Code or Composite symbologies require a fixed width to height ratio For these barcodes the height will be calculated accordingly 7 8 3 2 Module Width 1 1000 mm If the size mode is set to
29. al licensing see 8 2 2 without internet access 8 2 1 Online Activation using an Activation Key The online product activation is the preferred licensing method if you received an activation key from TEC IT licensing i E f O alin L Please enter the activation key and your address information Activation Key E aS Company Country ZIP City Email address to send your license information to Figure 29 License Dialog Online Activation In the topmost field you have to enter your activation key All fields are required A license certificate is sent to the given Email address automatically Confirm by clicking Send A message informs you about the successful activation In case of problems or errors please get in touch with TEC IT WWW TEC IT COM Page 55 of 60 8 2 2 Manual Licensing Manual licensing is the alternative method for licensing if your system has no Internet connection Select Manual licensing and enter the license data as provided by TEC IT gt Please enter the license data exactly as you received it from TEC IT Spacing and upper lower case letters are to be considered To avoid typographical errors please insert the data using copy and paste from the email containing your license data whenever possible gt Single licenses If you purchased a Single License you need to provide the so called System ID or hostname on LIN
30. ase functionality such as inserting a barcode and manually changing bar code properties is still supported Table 2 General Options Word Add In 5 Supported in 10 7 and later WWW TEC IT COM Page 10 of 60 Mail Merge Options Description Embed barcode as EMF This option applies if you perform a mail merge into a new document By default the bar codes are embedded as EMF image a vector format but EMF is sometimes scaled down depending on Word compatibility mode Uncheck this option if you want to embed a barcode ActiveX control instead of an EMF image into the merged document no scaling but needs more CPU Enable logging for mail merge During a mail merge the bar code generator can log bar code errors and resizing events e g barcode size was changed because of data content The log is displayed after the mail merge It helps you to determine the reason for errors or layout changes You can localize the record which created the wrong or missing bar code correct the data and print this record again Show progress bar in mail merge Enable this option to show a progress during a mail merge Beware that the progress bar only shows up when you have bar codes in your document Suppress error notifications Enable this option if you don t want to receive notifications or confirmation messages during a mail merge Be aware then that TBarCode Office provides no feedback regarding clipped unreadable or
31. bology If the composite component is enabled the data for the 2D composite component has to be separated from the linear component with a vertical bar Example 1234567890123 CompositeData 20 Formerly known as EAN UCC Composite Symbology 2 Formerly known as RSS Reduced Space Symbology Expanded Stacked WWW TEC IT COM Page 53 of 60 If a symbology has a fixed data length such as RSS 14 the vertical bar is optional All remaining characters after the 14 digit will be encoded into the 2D component automatically 7 15 2 Segments per Row For the RSS Expanded Stacked symbology you can adjust the number of data segments per row Allowed are even values between 2 and 22 This parameter influences the width to height ratio of the barcode symbol WWW TEC IT COM Page 54 of 60 8 Licensing 8 1 License Types Please check out http www tec it com order Default aspx for available license types and pricing 8 2 Entering your License Data The license information is entered in the following dialog To enter the license data select License from the TBarCode Office panel Usually the software is activated online see 8 2 1 Online activation is not possible or you prefer manual activation Please get in touch us with us if your system has no internet access or if you prefer to use the manual activation for any reason We will be glad to send you the license data which is suitable for manu
32. ce class 0 999 7 11 5 2 Country code 0 999 7 11 5 3 Postal code 9 digits 7 12 Adjust Properties PDF417 7 12 1 PDF417 7 12 11 Rows 3 90 7 12 1 2 Row height 1 1000 mm 7 12 1 3 Columns 1 30 7 12 1 4 Error Correction Level 7 12 1 5 Encoding Mode 7 12 2 MicroPDF417 7 12 2 1 Mode 7 12 2 2 Version 7 12 3 Macro PDF417 structured append 7 13 Adjust Properties QR Code QR Code 2005 7 13 1 Format Application Indicator 7 13 2 Symbol Version Size 7 13 3 Error Correction Level 7 13 4 Mask Pattern 7 13 5 Compaction 7 13 6 Structured Append 7 13 6 1 Use Structured Append 7 13 6 2 Parity Byte 0 255 7 13 6 3 Number of all Symbols 2 16 7 13 6 4 Index of this Symbol 1 16 7 14 Adjust Properties Micro QR Code 7 14 1 Symbol Version Size 7 14 2 Error Correction Level 7 14 3 Mask Pattern 7 14 4 Compaction 7 15 Adjust Properties Composite RSS 7 15 1 Composite Component 7 15 11 Data Input for the GS1 Composite Symbology 7 15 2 Segments per Row 8 Licensing 8 1 License Types 8 2 Entering your License Data 8 2 1 Online Activation using an Activation Key 8 2 2 Manual Licensing 9 Contact and Support Information Appendix A Related Downloads A 1 For Software Developers A 2 Barcode Reference Appendix B TBarCode INI File B 1 Compatible Draw Mode B 2 Site Lock OCX only B 3 License TBarCode Appendix C FAQ 1 1 List of Figures Figure 1 Register Add In for All Users Figure 2 TBarCode Office User
33. ctivate the Mailings tab Select or create a recipient list Open the panel see 5 1 Select a barcode type and enter the barcode data For inserting merge fields use the Insert Fields button in the panel Merge fields are only available if you have selected a recipient list Then click Insert Barcode Adjust the barcode size width height etc Test the mail merge Switch back to the Mailings tab then click Finish amp Merge For testing we recommend to perform a mail merge into a new document Select about 10 records and make a test print f possible verify the bar code with a bar code scanner Make sure the resulting layout is OK if you have received a resizing warning EE a Layout References Mailings View Add Ins DT o Signin Share E EE E 572 ay 3 Rules 3 K4 gt bi Ep Z QS Match Fields Find Recipient Envelopes Labels Start Mail Select Edit Highlight Address Greeting Insert Merge Previe Finish amp Merge Recipients Recipient List Merge Fields Block Line Field Update Labe Results EF Check for Errors Merger Create Start Mail Merge Write amp Insert Fields Preview Results h Edit Individual Documents a Ba Print Documents EX Send Email Messages Barcode Codelzs ly Data First_Name Insert Fields Herbert Size Fit into Bounding Box r Module Width auto Width 79 075 Heig
34. ctured append a large amount of input data which is split up into multiple barcode sym bols can be re joined correctly even if the barcodes are read in the wrong order 7 11 4 1 Use structured append Activate this option if structured append should be activated 7 11 4 2 Number of all symbols 2 8 The total number of MaxiCode symbols must be specified in this field 7 11 4 3 Index of this symbol 1 8 The symbol identification number index can be assigned to each MaxiCode symbol Its value can range from 1 to 8 The index is used for identifying the correct re joining order 7 11 5 Structured Carrier Message SCM MaxiCode was originally developed by UPS United Parcel Service The operating modes 2 and 3 Structured Carrier Message provide the additional data fields Service Class Country Code and Postal Code These fields can also be specified by escape sequences in the Barcode data alias Text property For more information please refer to the Barcode Reference see Appendix A 7 11 5 1 Service class 0 999 Specifies the service class used with within the SCM mode 2 or 3 7 11 5 2 Country code 0 999 Specifies the country code used with within the SCM mode 2 or 3 7 11 5 3 Postal code 9 digits Specifies the postal code used with within the SCM mode 2 or 3 Mode 2 up to 9 digits can be specified Mode 3 up to 6 characters digits and uppercase letters can be specified WWW TEC IT C
35. ded as barcode Depending on the selected barcode type you can encode different kinds of data Some barcodes can be used to encode digits only Others allow the usage of digits and a limited number of special characters like or Again others can be used to encode arbitrary alphanumeric data For more information on barcode types and on codeable data please refer to the Barcode Refe rence see Appendix A The number of letters that the data currently contains is shown below Barcode Data gt Ifthe Barcode Data cannot be represented with the selected symbology a big X is drawn instead of the barcode Additionally an error code and a short error description are displayed 7 2 4 Encoding Mode The Encoding Mode specifies how the input data should be interpreted gt Data is always passed as UNICODE stream to TBarCode OCX As UNICODE characters always consist of 2 bytes and most of the barcode types are only able to encode one byte per character it is not always clear how the input data should be interpreted So we give you the possibility to decide yourself gt Per default the input data is converted to the selected Code Page see below If other kinds of interpretations are needed you have to change this property You have following possibilities Value Description Convert to Code Page Converts the input data to the code page which is selected in the property Code Pag
36. e default No conversion Lower bytes only Considers only the lower bytes of the input characters the higher bytes are ignored Bytestream Lower before higher byte The data is passed as it is No conversion is done Both bytes are considered The lower byte is passed before the higher byte Bytestream Reverse Higher before lower byte Consider both bytes but change the order of lower and higher byte That means the higher byte is encoded before the lower byte Table 6 Compression 7 2 5 Code page The code page is related to the property Encoding Mode It is only considered if the encoding mode is set to Convert to Code Page You can choose among several pre defined code pages e g ANSI ISO 8559 1 Latin I UTF 8 Shift JIS or add the ID of a custom code page 7 2 6 Format Subset The format string is used for formatting the utilizable data of the barcode prior to encoding it The format string is built upon placeholders which can be combined with constant data characters to build the final data string Certain control characters make it possible to change the Subsets for Code 128 and GS1 EAN UCC 128 or to define the desired start stop character of CODABAR For detailed information on format strings please refer to the Barcode Reference see Appendix A WWW TEC IT COM Page 27 of 60 7 2 7 Check Digit Here you can set the calculation method of the check digit Whether you need a check digit or
37. e templates With these pre defined settings it is easy to generate barcodes which comply with common barcode standards The settings from the template are applied to the barcode See section 5 3 1 Templates Barcode Select the required barcode type from the list Data Enter the data for the barcode in the field Barcode Data Whenever you click into a cell of your spreadsheet the data of this cell is automatically copied into this field Leading and trailing white space characters newline spaces are removed Linkto Cell The button Link to Cell allows you to link a barcode with a specific cell This is useful to create dynamic bar codes which update whenever the content of the linked cell is changed Size Adjust the appearance of the barcode by using the fields Module Width Width and Height By clicking on the measure unit next to Size in you can toggle between millimeters and mils a mil is one thousandth of an inch 0 0254 millimeters Choose the suitable sizing mode Fit into Bounding Box The barcode is always drawn in the size of the bounding box The module width adapts to the amount of data to be encoded Fixed Module Width The size of the barcode depends on the amount of data to be encoded the module width is fixed Fit to Selected Cell The size of the barcode is adjusted to the size of the spreadsheet cell Automatically Link to Cell If checked the created barcodes are automatically linked to the cells Insert Ba
38. e width gt Be careful Setting the bar width reduction to more than 50 percent might leave the bar code unreadable When using this feature we recommend you to do some test scans to make sure that the bar code can be scanned correctly A common value to start with is 15 7 3 1 5 Bearer Bars Usually bearer bars are used with the ITF 14 or sometimes with the Interleaved 2 of 5 or the DPD symbology only The bearer bars were introduced to equalize the pressure exerted by the printing plate over the entire surface of soft materials They also enhance the reading reliability by helping to reduce the probability of misreads by skewed scanning beams For some types like UPC and EAN the bearer bars must be set to None Value Description None Do not print bearer bars Top and Bottom Print bearer bars at the top and the bottom of the symbol Rectangle Print bearer bars on all 4 sides of the symbol For rectangular bearer bars the quiet zone see section 7 3 1 7 must be at least 12 times the module width Otherwise no bearer bars will be printed Top Print bearer bars at the top of the symbol Bottom Print bearer bars at the bottom of the symbol Table 8 Bearer Bars 7 3 1 6 Bearer Bar Width 1 1000 mm Sets the width of the bearer bars in 1 1000 mm gt The minimum width of the bearer bars is two times the module width which is also used as default value If any smaller value is e
39. ed all bar codes of the actual document are redrawn and the size is updated This behavior is enabled by default and can be disabled in the options menu see 5 2 3 6 3 4 Interferences with VBA In some cases the TBarCode Panel can prevent execution of VBA code The reason is that the TBarCode Panel switches to Design Mode this is required to allow bar code controls to be selected and changed 15 Make sure that you have enabled Create one bar code per cell in the Add In options 16 Introduced in TBarCode Office Version 10 5 3 WWW TEC IT COM Page 23 of 60 As a workaround VBA programmers can prevent the Add In from switching to Design mode if they disable screen updating Application ScreenUpdating False Your VBA Code e g open workbook Application ScreenUpdating True This allows VBA code to be run without interruption as long as the user does not open the TBarCode Panel or insert a bar code gt Please contact us if you have macros which are disturbed by the TBarCode Add In 6 3 5 Limitations Excel Add In Ifyou create a list of bar codes the number of bar code controls per insert operation is limited to 600 6 3 5 1 System Resources Excel uses GDI objects for drawing the bar code images There is a system limit for GDI objects which has an influence to the number of bar codes and bar code drawing operations per Excel session If all free resources have been consumed you will
40. elect a document property 8 and click Insert A placeholder for the document property will be inserted into the Barcode Data field 6 Document5 Word m x Home EN EE References Mailings Un Tae Add Ins DT t t Signin Q Share aal Ed insert Barcode eS Ed TEC T Website 1 TBarCode Panel Ed Hep Barcode Insert Fields TBarCode Office ME Mail Merge Properties Essens Sequences i Barcode Select a document property 4 Code 128 2 r Application name Data Date Creation date TN ate 13 Insert Fields Size Fit into Bounding Box X Last print date Module Width 0 258 Last save time Manager Width 79 957 Number of bytes Number of characters Height 19 879 Number of characters with spaces EE Number of hidden Slides Si Size in mm Barcode Settings Pagelofi Line 1 Owords EZ German Austria 5 EA Ba B Figure 10 Insert Document Properties You can enter the placeholder format also directly into the Barcode Data field Property name Please note that the property names are case sensitive p If the property name is unknown or the placeholder format is incorrect the unresolved place holder sequence will be encoded instead of the property value In Microsoft Word not only standard properties but also custom properties or content type server properties can be assigned
41. epending on the bounding rectangle and the number of rows Some label specifications require a specific ratio between module width and row height Example If a ratio of 1 3 is required you might set the module width to 254 and the row height to 762 WWW TEC IT COM Page 46 of 60 7 12 1 3 Columns 1 30 Defines the number of columns of a PDF417 symbol Values between 1 and 30 are allowed The start stop and line indicator columns which are fixed parts of the symbol are not taken into ac count Default the number of columns is calculated automatically depending on the number of input characters gt You should not set both rows AND columns to a constant value 7 12 1 4 Error Correction Level Sets the error correction level Values between 0 and 8 are allowed The error correction level defines the number of code words which are used for error recognition correction Each PDF417 barcode contains at least two code words Level 0 2 code words Level 1 4 code words Level 2 8 code words And so on Levels 3 to 7 are using 16 32 64 128 and 256 code words Level 8 uses 512 code words for error correction Value Description Default Depending on the amount of input data the error correction level is set to a value between 2 and 5 automatically 0 Error recognition only no error correction is possible 2 code words are used for calculating a check sum 1 Error correction 4 code w
42. er Message with 9 digits Postal Code digits only Mode 3 SCM Alphanumeric gt Structured Carrier Message with up to 6 characters Postal Code alphanumeric characters Mode 4 No SCM encoding of numeric and alphanumeric characters incl Standard Error Correction Mode 5 Full EEC like mode 4 but with maximum error correction safer but less data possible Table 16 MaxiCode Compaction Modes 7 11 2 Undercut 0 100 The undercut influences the diameter of the hexagonal barcode elements In new applications it is recommended according to the AIM standard to use an undercut setting of 75 default 7 11 3 Preamble Options Used in particular open system standards Under Preamble date the last two digits of a year can be entered They are automatically inserted into the data stream in a predefined place The preamble can also be specified by escape sequences in the Barcode data alias Text proper ty To learn more about this option please refer to the Barcode Reference see Appendix A WWW TEC IT COM Page 44 of 60 7 11 3 1 Use Preamble Enables the preamble mode if checked 7 11 3 2 Preamble date 0 99 This is the value of the preamble year to be encoded in the MaxiCode symbol 7 11 4 Structured Append Structured append is used for appending multiple MaxiCode symbols to one chain Therefore some tee header information total number of barcodes index will be included in the barcode Using stru
43. ey from TEC IT http www tec it com order gt For more information on licensing TBarCode Office please refer to chapter 8 1 For more information on mailings please refer to chapter 6 2 WWW TEC IT COM Page 7 of 60 4 Installation 4 1 Requirements TBarCode Office can be used with the following Microsoft Office versions Microsoft Office 2007 Microsoft Office 2010 Microsoft Office 2013 Microsoft Office 2016 Excel 2016 with restrictions TBarCode Office can be used with the following operating systems Windows XP x86 with Service Pack 3 all editions except Starter Edition Windows Vista with Service Pack 2 all editions except Starter Edition Windows 7 with Service Pack 1 Windows 8 Windows 10 Windows Server 2003 with Service Pack 23 Windows Server 2003 R2 Windows Server 2008 with Service Pack 2 Windows Server 2008 R2 SP1 Windows Server 2012 2012 R2 4 1 1 Dependencies The following dependencies must be installed Visual Studio 2010 Tools for Office Runtime VSTO 4 0 Microsoft NET Framework 4 0 Client Profile Extended or higher download here 4 2 Download and Setup Download TBarCode Office from hitp www tec it com Download gt TBarCode Office and execute the setup application gt Note For installing TBarCode Office administrative rights are required During setup you can decide if you want to install the add in only for the current user
44. figurable in a later version WWW TEC IT COM Page 19 of 60 6 2 5 Limitations Word Add In Please take care of the following limitations when using the Word Add In The number of bar code controls is limited to 256 controls per master document This limit affects only the master document and not the printed already merged documents If you merge into a new document the number of bar codes in the generated document is limited to 4000 This limit has been introduced because of system resource consumption The supported rules for mail merge documents are Next Record and Next Record If The layout wrapping style of the barcode control must be Inline with text otherwise the bar code control is not recognized and cannot be updated during the mail merge The mail merge data source must be an OLE DB data connection Go to Word Options Advanced General and make sure that Confirm file format conversion on open is activated Then open the data file see 6 2 1 In the Confirm Data Source dialog select OLE DB Database File 6 2 5 1 System Resources Word uses GDI Objects for drawing the bar code images There is a system limit for GDI objects which also limits the number of bar codes bar code drawing operations per Word session If all free resources have been consumed you will see that the application loses responsivity A restart of the application usually frees up the resources again The following operations are
45. g so called Application Identifiers Als A FNC1 is encoded at first position automatically Table 14 Codablock F Code Formats WWW TEC IT COM Page 41 of 60 7 10 Adjust Properties Data Matrix gt Please note TBarCode always encodes data using the newest ECC200 error correction method In this dialog you can set Data Matrix specific properties Data Matrix Properties es Code format z Symbol size Default bal Enforce binary encoding Show as rectangle u Structured append Use structured append Number of all symbols 2 16 12 Index of this symbol 1 16 1 File ID 1 64516 1 Cancel Figure 23 Advanced Properties Data Matrix 7 10 1 Code Format Sets the code format which is used for encoding the barcode data Value Description Default The standard format of Data Matrix no special header included UCC EAN GS1 Special format defined by GS1 formerly UCC EAN for encoding Application Identifiers This format adds the function character FNC1 at 1st position in the symbol Industry This setting supports peculiar industry formats It adds FNC1 at 2nd position Macro 05 gt Rs05Gs is encoded at the beginning of the code Macro 06 gt Rs06Gs is encoded at the beginning of the code Reader Special mode used for reader programming Programming DP Postmatrix Adds the additional bars for Deutsche Post Postmatrix code Table 15 Data Matri
46. g workstations with custom font sizes DPI lt gt 96 may result in resized bar codes after opening a workbook This behavior is by design of Excel Sharing Excel documents among workstations with different screen resolution e g user A has 1024 x 768 Pixel and user B has 1600x1200 Pixel screen resolution forces Excel to scale the bar code size unwantedly This behavior is by design of Excel 17 Introduced in TBarCode Office Version 10 5 5 18 Microsoft Excel 2016 initial release seems to consume more GDI resources but this may be improved in later versions WWW TEC IT COM Page 24 of 60 Starting with version 10 5 3 a workaround which forces a redraw of all bar codes during workbook open was introduced see 6 3 3 The workaround needs TBarCode Office to be installed More issues and possible workarounds see our online FAQ 19 The workaround has been tested on Windows 7 and 8 with Office 2007 2010 and 2013 Please note that there is no guarantee that the issue has been solved for all platforms and Office versions WWW TEC IT COM Page 25 of 60 7 Barcode Settings 7 1 Introduction The property dialog of TBarCode Office gives you access to advanced bar code properties Open the dialog with the Barcode Settings link in the panel 7 2 Property Page Barcode The first property page is the Barcode tab It contains basic barcode adjustments like Barcode Type Symbology Barcode Data etc For most ap
47. hoose CC A CC B or CC C type depending on the length of the input data CC A Use composite component A CC A CC A is a variant of the MicroPDF417 symbology with a unique combination of row address patterns RAP It is the smallest variant of the 2 dimensional composite component Up to 56 characters can be coded also alphanumeric with 3 to 12 rows and 4 columns CC B Use composite component B CC B CC B is a subset of the MicroPDF417 Symbol which is identified by the code word 920 CC B will be chosen automatically when CC A has not enough capacity in Auto mode CC B encodes up to 338 Characters alphanumeric in 3 to 12 rows and 2 to 4 columns CC C Use composite component C CC C The CC C structure is a PDF417 Symbol which is identified by the internal code word 920 920 is the first code word after the symbol length indicator The CC C structure can be used as a 2D composite component of a UCC EAN 128 Composite Symbol It has the largest data capacity among the composite symbologies It encodes numbers and alphanumeric characters with up to 2361 characters length in 3 to 30 rows It uses up to 30 data error checking code columns Table 23 Composite Component Format gt You can add Composite Components to the following symbologies EAN 8 EAN 13 UPC E UPC A GS1 DataBar RSS family and GS1 128 gt CC C is available for GS1 UCC EAN 1 28 only 7 15 1 1 Data Input for the GS1 Composite Sym
48. ht 32 103 Size in mm 5 Insert Barcode m a 1 B z Pagelof1 Line1 Owords German Austria EA Figure 7 Guide for Using Mailings gt Finish amp Merge Print Documents uses less resources as the other methods gt During the bar code generation process you should not use the Clipboard Close all applications which query the Clipboard e g Microsoft Outlook with Office Clipboard 7 If you encounter reading or quality problems check out our Barcode Reference section Creating Optimal Barcodes Thermal transfer printers require a special adaption of the module width parameter to the printer resolution DPI WWW TEC IT COM Page 15 of 60 6 2 2 Create Labels Microsoft Word s mail merge wizard can also be used to create barcode labels Please follow these steps Start with a new Word document Activate the Mailings tab Select Start Mail Merge and click Labels A dialog will pop up You can select different label sizes Select or create a recipient list Open the TBarCode Office panel see 5 1 Select a barcode type and enter barcode data Click inside the first cell of the table and click Insert Barcode Finish the layout of the first label Use nsert Field Now switch back to the Mailings tab and click Update Labels This automatically inserts the content from the first table cell first label into all o
49. internal data structure is regulated by different modes The Structured Carrier Message mode was defined by the United Parcel Service UPS Data can be encoded with two different error correction levels SEC Standard Error Correction and EEC Enhanced Error Correction MaxiCode is very flexible With structured append you can divide larger quantities of data into seve ral MaxiCode symbols see also section 7 4 Property Page Multiple Barcodes they are then re joined by the scanner The maximum data capacity of one symbol is 93 characters The actual quantity of the utilizable data depends on the selected mode the number of special characters and whether numeric sequences are used or not numeric Sequences can be encoded using less space than ASCII data Last but not least the error correction level influences data capacity MaxiCode Properties ES Mode 4 Standard symbol Undercut 0 100 V Default Preamble options Use preamble E Preamble date 0 99 96 Structured append Structured carrier message SCM Use structured append E Service class 0 999 Number of all symbols 2 8 2 Country code 0 999 Index of this symbol 1 8 fi Postal code 9 digits oes Figure 24 Advanced Properties MaxiCode 7 11 1 Mode Selects the mode for the actual symbol Default Mode 4 Value Description Default Is egual to Mode 4 Mode 2 SCM Numeric gt Structured Carri
50. ion Strip leading and trailing whitespaces Typing a new line or a space in the barcode data text field also takes effect in the encoding of the barcode data If this option is checked TBarCode Office removes spaces and new lines before and after the actual data of the barcode Redraw on open If the screen resolution has been changed the bar code controls can be updated redrawn on document open automatically This behavior should help with the resizing issue described in 6 3 6 1 If you encounter problems with embedded documents turn off this option Disable warnings Use this option if you want to suppress warnings like Cannot update bar code size during document loading If warnings are disabled there is also no check for low system resources GDI Objects when inserting or refreshing a bar code Insert Options Description Ignore empty cells If you have selected multiple cells you can omit bar code creation for empty cells This option prevents creation of bar codes without data Create One Barcode per Cell If you have selected multiple cells you can create one bar code per cell This option allows you to create a list of bar codes Table 5 Option Settings Excel Add In 5 3 User Interface Common for Word and Excel 5 3 1 Templates In this dialog you can choose one of the provided barcode templates Each template provides pre defined barcode settings which comply with the respective barcode s
51. it at the last position If you enter 12 digits as barcode data this last digit the check digit will be calculated and inserted automatically If you enter all 13 digits you have to supply the correct check digit by yourself otherwise you 066000 7621 receive an error gt TBarCode verifies the correctness of the check digit supplied by your application gt If not provided in your input data the check digit will be calculated and appended automatically 7 2 8 Compression To increment the capacity of barcodes you can compress the Barcode Data This means that the data provided by the user will be compressed before it is encoded as barcode The compression is only available for barcodes which allow the encoding of arbitrary binary data and a variable length of input data By default the compression is set to None Value Description None The barcode data will not be compressed It will be stored in the barcode as is default Deflate RFC 1951 The barcode data will be compressed using the Deflate algorithm We recommend using this algorithm if data compression is required GZip RFC 1952 The barcode data will be compressed using the GNU zip algorithm ZLib RFC 1950 The barcode data will be compressed using the ZLib algorithm Table 7 Compression WWW TEC IT COM Page 28 of 60 gt Note When reading compressed barcode data you will have to decompress it in order to res
52. ith 600 dpi and then scanned with a hardware scanner the resolution should be set to 600 dpi Good print quality As decoder select Hardware If the barcode is printed with 600 dpi transmitted with a fax device 200 dpi and then scanned with a hardware scanner the resolution should be set to 200 dpi Fax As decoder select Hardware If the barcode is printed with a laser printer 600 dpi and if it is then scanned with a flat bed scanner 150 dpi and then decoded via software you should select a custom resolution of 150 dpi As decoder select Software Value Description 96 dpi Screen Specifies the default screen resolution 200 dpi Fax Specifies the default fax resolution 202 dpi Thermo transfer This resolution is used by thermo transfer printers e g by Zebra printers 300 dpi Poor print quality Specifies a low printer resolution 600 dpi Good print quality Specifies the standard printer resolution Custom dpi Specifies any other resolution The dpi value can be entered in the input box on the right see section 7 3 3 4 Table 12 Resolution 7 3 3 4 Custom Resolution DPI Specifies the custom dpi value for the size mode Minimal Optimize for readability if Resolution is set to Custom dpi 7 3 3 5 Decoder Specifies which kind of decoder is used for reading the barcode content size mode Minimal Optimize for readability
53. ition NOTE This button changes to Update Barcode if a barcode is selected in the document Clipboard You can copy an image of the actual bar code into the clipboard by holding down the Shift key while clicking Insert Barcode This function copies the bar code as high resolution graphics EMF and not as ActiveX Control Options Options allows you to configure specific Add In options e g mail merge options For more information see section 6 2 License The link License opens a dialog for entering the license data See chapter 8 m About About displays the product version and copyright information Table 1 TBarCode Office Panel in Word 5 1 3 Options In the options dialog you can adjust specific settings for the Word Add In In most cases it is not required to change them la TBarCode Office Options General 7 Encode document properties E Reference content controls E Disable warnings 7 Strip leading and trailing whitespace 4 kml Mail Merge V Embed barcode as EMF Y Enable logging bar codes V Show progress bar E Suppress error notifications Figure 3 Options Word Add In General Options Description Strip leading and trailing whitespace Typing a new line or a space in the data input field also takes effect in the barcode data If this option is checked TBarCode Office removes spaces and new lines bef
54. l barcode specific adjustments You can access these adjustments by clicking on the Adjust button in the Barcode tab This button is available for Aztec Code Codablock F Data Matrix MaxiCode MicroPDF417 PDF417 PDF417 Truncated QR Code Micro QR Code and all Composite Symbologies TBarCode10 Properties sl Barcode Appearance Multiple Barcodes Font Color Basic settings Barcode type symbology Barcode data Adjust Properties a 17 characters 4 p r Advanced settings Encoding mode Convert to Code Pae sl Code page Defaut o a eooo Format Subset aes V Default Check digit Dea Compression None sl Suppress error messages Translate escape sequences License About cet v we Figure 20 Adjust The following sections 7 8 to 7 15 will give an overview over barcode specific properties gt Please take care when modifying these properties Some settings may result in unreadable barcodes Always make a test scan in case of doubt WWW TEC IT COM Page 38 of 60 7 8 Adjust Properties Aztec Code Aztec Code is a 2 dimensional Matrix Code Characteristic for the Aztec Code is the finder in the center of the symbol which contains of 3 to 5 lapping squares Aztec Code Properties Es General Format format specifier EE 2 digits 1 char Symbol size Defaut Enforce binary encoding u Enable Aztec Runes m Error correc
55. lit up and encoded into multiple barcode symbols automatically Multiple barcodes are supported for the following symbologies Aztec Code Data Matrix MicroPDF417 PDF417 PDF417 Truncated QR Code WWW TEC IT COM Page 35 of 60 7 5 Property Page Font In this menu you can adjust the font for the human readable text TBarCode10 Properties ei Barcode Appearance Multiple Barcodes Font Color Properties Eont Size Times New Roman r Effects 7 Bold 7 Underline Italie 7 Strikeout Sample Text Times New Roman Figure 18 Property Page Font 7 5 1 Properties The entry Font is pre selected 7 5 2 Font Selects the font type The combo box lists all fonts which are available under your operating system gt Please consider that some fonts can t be rotated Therefore if rotation is required we recommend selecting a TrueType font 7 5 3 Size Specifies the font size in points 7 5 4 Effects Applies additional text effects Please check the corresponding option to create bold italic under lined and or stroked out text 7 5 5 Sample Text Shows a preview of the selected font WWW TEC IT COM Page 36 of 60 7 6 Property Page Color The colors of the barcode of the human readable text and of the background can be set here TBarCode10 Properties Es Barcode Appearance Multiple Barcodes Font
56. look runs in the background problem with Clipboard Manager Close Outlook and avoid the Clipboard while the mail merge is active The Word function Save amp Send does not refresh the document properties in the bar code controls only printing does Word 2013 and 2016 renders the bar code object over and over after insert WWW TEC IT COM Page 20 of 60 The mail merge preview does not update the bar code automatically Workaround Move to the record you want to preview Select the bar code and click Update in the TBarCode Panel Then the barcode is updated with actual data Users of the Adobe Acrobat Pro Add In may experience a crash when using the Merge to PDF function Mailings In addition they cannot immediately switch to Design mode by selecting a bar code they have to open the TBarCode Office panel first Undo Ctrl Z on a bar code object can lead to uninitialized bar codes after Save Open More issues and possible workarounds see our online FAQ 14 This limit is part of a workaround introduced with Version 10 5 6 WWW TEC IT COM Page 21 of 60 6 3 Microsoft Excel 6 3 1 Link a Cell with a Barcode The TBarCode Office add in for Microsoft Excel is able to link cell contents to barcodes So you can create dynamic barcodes which update automatically whenever a cell is changed There are different ways to do this Please follow the steps below 6 3 1 1 Manual Linking Start with a
57. missing bar codes also no warnings about low system resources during a mail merge Table 3 Mail Merge Options Word Add In 5 2 TBarCode Office for Microsoft Excel 5 2 1 Activating the Barcode Panel To activate or open the task pane switch to the Add Ins tab and then click on the panel button The TBarCode Office panel appears immediately on the right side of the document Bookl Excel Drawing To fH Oo x Home Insert Page Layout Formulas Data Review View Developer Add Ins Format x Sign in 2 Share mn Ed insert Barcode EZI Ed TEC T Website TBarCode Panel Ed Hep Barcode A TBarCode fe EMBED TBarCode10 TBarCode10 1 A B C D E F G H I J E id TBarCode Office ME 2 Barcode 3 o Code128 B 5 6 Office Add In st 7 8 Office Add in 9 10 Link to cel 11 12 Size 13 Fit into Bounding Box r Module Width 0 449 15 16 Width 79 904 17 Height 21 960 Size in mm 19 6 20 Automatically Link to Cell 21 2 Update Barcode 23 Options License About Bl u Sheetl 7 x Ready 3 Ed E N I 100 Figure 4 TBarCode Office User Interface in Excel WWW TEC IT COM Page 11 of 60 5 22 TBarCode Office Panel In the TBarCode Office panel you make all your adjustments for the barcode to be encoded Options Description 0 Opens a list of barcod
58. nd after the barcode symbol As a rule of thumb the quiet zone should be ten times the dimension of the module width or at least 1 4 inch 6 5 mm The exact value depends on the selected barcode type gt Please note A few barcode types provide the required quiet zone automatically These bar codes are EAN 8 EAN 13 UPC A UPC E and ISBN Adjusting the quiet zone for these symbologies will add always an additional white space 7 3 2 Text Options The text options allow the adjustment of the human readable text The human readable text is usually printed below the barcode symbol and shows the content of the barcode gt Not all barcode specifications support the printing of human readable text If human readable text is not supported the following setting will be ignored 7 3 2 1 Print Text Specifies whether the barcode data is printed as human readable text or not Default Yes 7 3 2 2 Above Symbol Prints the human readable text above the symbol default below gt For some barcodes e g UPC A EAN 13 the adjustment Above symbol is not permitted 7 3 2 3 Alignment Changes the alignment of the human readable text Value Description Default Uses the default text alignment Center Left Aligns the human readable text to the left Right Aligns the human readable text to the right WWW TEC IT COM Page 32 of 60 Center Centers the human re
59. ntered the minimum width will be used instead Note If the bearer bar width is set to zero no bearer bars are printed 7 3 1 7 Draw Mode Due to problems with certain printer drivers TBarCode is able to use different methods to draw bar codes You can choose between following modes Value Description Default The bar codes are drawn in the advanced mode This provides the best quality Advanced Compatible The bar codes are drawn in the compatible mode This decreases the quality slightly but is supported by the most printers Dual The bar codes are drawn in the dual mode This is a combination of the Advanced and Compatible mode Table 9 Draw Mode WWW TEC IT COM Page 31 of 60 If you want to use the Compatible draw mode as preferred setting you can specify this in an ini file For more information please refer to Appendix B 7 3 1 8 Quiet Zone The quiet zone is an empty area outside the barcode It helps the scanner to read the barcode correctly Clicking the Adjust button opens the following dialog Quiet Zone ls General Unit mm X Left 10 Right ad Top 0 Bottom 0 cnc Figure 16 Quiet Zone Adjustment In this dialog you adjust the quiet zone for all four sides of the barcode Possible units are Modules Millimeters Mils and Pixels Default No quiet zone is added For most 1D barcodes a quiet zone should be maintained directly before a
60. o The preamble gt RS 0 6 GS precedes the barcode data CC A Data Mode Uses Base 928 compaction and processes input data as byte array CC B Data Mode a binary compaction Base 900 The barcode data is prefixed with a reserved code word Table 18 Micro PDF417 Compaction Modes 7 12 2 2 Version Specifies the size of the symbol in terms of codeword columns and MicroPDF417 rows 7 12 3 Macro PDF417 structured append Macro PDF417 is used for connecting multiple PDF417 symbols PDF417 PDF417 Truncated or MicroPDF417 into one chain For each symbol of the chain you can specify the Segment Index of the actual symbol Last symbol specifies that the actual symbol is the last symbol in the chain the File ID which identifies one chain of symbols optional information File name Segment count Time stamp Sender Addressee File size Checksum CCITT 16 WWW TEC IT COM Page 48 of 60 7 13 Adjust Properties QR Code QR Code 2005 The QR Code is a 2 dimensional matrix symbology like Data Matrix It has a remarkable data capacity of up to 3000 ASCII characters or 7000 digits The QR Code symbology was designed to read a lot of data within a minimum of time QR Code means Quick Response Code QR Code 2005 is a variant of QR Code which supports a default data encoding of Latin 1 instead of Kanji Japanese character set and is commonly used in Europe QR Code
61. o a few cells Open the panel see 5 1 Select a barcode type and set dimensions for the barcodes Select all the cells that you want to convert to barcodes Click Insert Barcode El ee Bookl Ex Ed Bookl Excel File Home Insert Pagelayout Formulas Data Review File Home Insert Pagelayout Formulas Data Review View Developer haa ms gn Ef insert Barcode Gol Ef insert Barcode Le LESI EJ TECTT Website IES EJ TECTT Website TBarCode TBarCode Panel K Heip Panel K Heip Barcode Barcode c2 v fe 123456789012 v fe A B c D A B c D E F 1 1 2 123456789012 2 3 3 123456789013 4 123456789014 4 123456789014 5 123456789015 5 123456789015 4 d 6 6 Sheetl lt Sheetl lt Ready 7 Average 123456789014 Count 4 Sul Ready 7 Ad 2 Signin Q Share TBarCode Office di Barcode Code18 z Data 123456789012 Link to Cell Size Oo Fit to Selected Cell a Module Width 0 584 Width Height Size in mm lt Automatically Link to Cell 5 Insert Barcode 100 Figure 13 Guide for Creating Barcode Lists 6 3 3 Updating Barcode Controls You may see a short notice Updating bar code controls when opening an Excel file In the Workbook_Open event the Add In verifies the actual screen resolution and compares it with the resolution stored in a custom document property If the resolution has been chang
62. option Display error if barcode is clipped This way if the barcode extends the size of the bounding rectangle an error is displayed instead of the bar code This option may help you to avoid truncated barcodes incorrect printouts can be detected immediately WWW TEC IT COM Page 34 of 60 7 4 Property Page Multiple Barcodes TBarCode10 Properties Barcode Appearance Multiple Barcodes Fort Color Multiple barcodes Enable multiple barcodes Rows IV Auto Data limit IV Columns IV Auto Structured append r Number of barcodes r Data limit per barcode bytes Min barcode distance 1 1000 mm Mode Standard Ei Horizontal IV Defaut Dynamic bounding rectangle Vertical IV Default Mode r Description Don t grow say If the options on this page are enabled multiple barcodes are generated as required Eva This is useful to encode large amounts of data The data is automatically split and Pd encoded in a sequence of barcodes This mode should only be used with 2D barcodes like Aztec Code Data Matrix PDF 417 OR Code etc oe ee m ww Figure 17 Property Page Multiple Barcodes 7 4 1 Enable Multiple Barcodes This option has been disabled in TBarCode Office It is available in the TBarCode SDK Barcode ActiveX Control Multiple barcodes can be used for encoding large quantities of data The data will be sp
63. ords are used for error correction information 2 Error correction 8 code words are used for error correction information 8 Error correction 512 code words are used for error correction information Table 17 PDF417 Error Correction Levels A higher error correction level adds more redundant information to the symbol Therefore the symbol will require more space for printing If the symbol is distorted through surface damage bad printing quality or dirt the error correction information can help to reconstruct the full infor mation contained in the PDF symbol reconstruction is done by the scanner gt The error correction algorithm Reed Solomon has the following limit for a successful reconstruction of data total number of not decodable characters 2 number of read errors must be smaller than number of error correcting code words 2 7 12 1 5 Encoding Mode Choose the encoding mode of the barcode Value Description Normal Default Analyzes the input data Depending on the input data either text numeric or binary compaction mode is used in order to keep the resulting symbol as small as possible Binary Compaction Uses binary mode for encoding no input data analysis This mode is recommended if you want to encode binary input data 7 12 2 MicroPDF417 These settings apply for the MicroPDF417 symbology only WWW TEC IT COM Page 47 of 60
64. ore and after the actual data in the barcode Encode document properties This option controls if placeholders for document properties e g Author should be resolved The placeholders are updated when editing the bar code and before printing If you encounter problems e g decreased responsiveness or you do not use document properties at all you can disable this option Reference content controls This options controls if placeholders for content controls e g TagID and form fields should be resolved The placeholders are updated when editing the bar code and before printing If you encounter problems or do not use content controls or form fields you can disable this option Disable warnings Enable this option if you don t want to receive warnings OLE DB connection bar code resizing low system resources You should not disable warnings if you have critical printing tasks with a higher volume of bar codes Deactivate events TBarCode Office is using application events in order to interact with Word and the actual user selection If you encounter problems or you use a VBA program or Add In which interferes with those events you have the possibility to deactivate the event integration If you do so you will lose mail merge functionality and auto updating of the task pane if you select a bar code Also placeholders for variable data e g document properties are no longer resolved before printing B
65. our license data in the ini file If you want to know how to do this please contact our support mailto support tec it com WWW TEC IT COM Page 59 of 60 Appendix C FAQ The frequently asked questions are located on our web page http www tec it com FAQ http www tec it com support fag tbarcode office aspx If you do not find the required answers please feel free to contact our support team mailto support tec it com WWW TEC IT COM Page 60 of 60
66. plications adjusting these settings will be suffi cient Additional parameters can be changed on demand button Adjust tabs Appearance Multiple Barcodes Font and Color TBarCode10 Properties a Barcode Appearance Multiple Barcodes Font Color Basic settings Barcode type symbology Barcode data Adjust Properties a 17 characters d p Advanced settings Encoding mode ConvettoCodePage sl Code page Defut sl zz Format Subset EER Ee NT V Default Check digit Deut Compression None sl Suppress error messages Translate escape sequences License About Co ees es vee Figure 14 Property Page Barcode 7 2 1 Barcode Type Symbology Here you adjust the barcode type Common linear barcode types are UPC USA EAN Europe GS1 128 Code 128 Code 39 2 of 5 Interleaved Common 2D barcode types are Data Matrix QR Code and PDF417 For information on the different barcode types symbologies please refer to the Barcode Refe rence see Appendix A 7 2 2 Button Adjust The Adjust button will open a barcode specific properties dialog for the selected barcode type symbology This button is available for 2D barcodes and for composite symbologies only Barcode specific settings are described in sections 7 7 to 7 15 WWW TEC IT COM Page 26 of 60 7 2 3 Barcode Data The content of this textbox will be enco
67. r Correction Level Defines the error correction level See OR Code section 7 13 3 7 14 3 Mask Pattern Sets the mask pattern See QR Code section 7 13 4 Note The Micro QR Code has only 4 mask patterns and not 8 like the QR Code 7 14 4 Compaction Defines the compaction mode See QR Code section 7 13 5 WWW TEC IT COM Page 52 of 60 7 15 Adjust Properties Composite RSS In this menu you can adjust the parameters for the GS1 Composite Symbology and for the GS1 DataBar Expanded Stacked symbology fa Composite GS1 DataBar RSS Properties Composite component character Segments per row GS1 Composite Symbology If Composite Symbology is enabled the folllowing rules apply for data encoding a If the base symbology requires a fixed number of input characters e g GS1 DataBar all input characters beyond the required amount will be encoded in the composite component automatically b If the base symbology allows a variable number of input characters the vertical bar must be used to seperate the composite data from the base data GS1 DataBar Expanded Stacked Default None V Default Cancel Figure 28 Advanced Properties Composite RSS 7 15 1 Composite Component Sets the 2D composite component in order to generate a GS1 Composite Symbology Value Description Default None Composite Symbologies are disabled Auto CC A B C Automatically c
68. rcode The button nsert Barcode inserts a barcode at the current position in your spreadsheet NOTE This button changes to Update Barcode if a barcode is selected in the document Barcode Settings Barcode Settings is used for adjusting additional parameters like bar width reduction or font and color settings For further information see chapter 7 Select all Barcodes The link Select all Barcodes selects all barcodes in the worksheet Refresh all Barcodes Redraws all barcodes in the worksheet reapplies linked cell content and resizes bar codes with fixed module width if data has changed m Options Options allows you to configure specific add in options For more information see section 5 2 3 License The link License opens a dialog for entering the license data See chapter 8 About About displays the product version and copyright information Table 4 TBarCode Office Panel in Excel 5 2 3 Options In the options dialog you can adjust specific settings for the Excel Add In fr TBarCode Office Options General Strip leading and trailing whitespace Y Redraw on open verify screen resolution IT Disable warnings Insert MultiSelect Ignore empty cells V Create one bar code per cell Figure 5 Options Excel Add In White space removal is adjustable in the options dialog WWW TEC IT COM Page 12 of 60 General Options Descript
69. s TEC IT TBarCode 10 0 Then edit the ini file gt Please Note The ini file is loaded together with the TBarCode DLL All settings which were taken from the ini file may later be overridden per program code or via the property pages of every single TBarCode instance B 1 Compatible Draw Mode In order to use the Compatible draw mode as initial setting draw GDI rectangles instead of the de fault output method add the following line to the ini file DRAW MODE UseGDIRect 1 Possible Options are 1 and 0 Compatible draw mode enabled or disabled gt In Word Excel and other office applications all barcode settings are saved and restored as part of the document files Therefore the draw mode setting will have no effect when opening an existing document but only when inserting a new barcode However this setting will change the draw mode setting effectively in TBarCode applications like TBarCode for SAP TFORMer etc B 2 Site Lock OCX only The site lock is provided for security reasons It only applies to the TBarCode OCX when it is scripted within Internet Explorer With this option you can specify which sites are allowed to execute critical function calls on the control and which are not DOMAIN LIST Site Lock Please refer to the TBarCode OCX Developer Reference Introduction Security for more infor mation B 3 License TBarCode In order to license TBarCode you can paste y
70. s clipped 7 4 Property Page Multiple Barcodes 7 4 1 Enable Multiple Barcodes 7 5 Property Page Font 7 5 1 Properties 7 5 2 Font 7 5 3 Size 7 5 4 Effects 7 5 5 Sample Text 7 6 Property Page Color 7 6 1 Properties 7 6 2 Color Set 7 6 3 Color Palette 7 6 4 Edit Custom Color 7 7 Adjust 7 8 Adjust Properties Aztec Code 7 8 1 Format Format Specifier 7 8 2 Symbol Size 7 8 3 Enforce binary encoding 7 8 4 Enable Aztec Runes 7 8 5 Error Correction in 0 90 7 8 6 Structured Append 7 8 6 1 Use structured append 7 8 6 2 Number of all symbols A Z 7 8 6 3 Index of this symbol 1 16 7 8 6 4 Message ID 7 9 Adjust Properties Codablock F 7 9 1 Rows 2 44 7 9 2 Columns 4 62 7 9 3 Row height 1 1000 mm 7 9 4 Separator height 1 1000 mm 7 9 5 Code format 7 10 Adjust Properties Data Matrix 7 10 1 Code Format 7 10 2 Symbol Size 7 10 3 Show as Rectangle 7 10 4 Structured Append 7 10 4 1 Use structured append 7 10 4 2 Number of all symbols 2 16 7 10 4 3 Index of this symbol 1 16 7 10 4 4 File ID 1 64516 7 11 Adjust Properties MaxiCode 7 11 1 Mode 7 11 2 Undercut 0 100 7 11 3 Preamble Options 7 11 Use Preamble el 7 11 3 2 Preamble date 0 99 7 11 4 Structured Append 7 11 41 Use structured append WWW TEC IT COM Page 3 of 60 7 11 4 2 Number of all symbols 2 8 7 11 4 3 Index of this symbol 1 8 7 11 5 Structured Carrier Message SCM 7 11 51 Servi
71. see that the application loses responsivity A restart of the application usually frees up the resources The following operations are sensitive regarding resource consumption Insertion Moving Refreshing a larger number of bar code controls Closing the TBarCode Panel disables design mode triggers a refresh Workarounds Reduce the number of bar codes per Excel sheet Don t open multiple workbooks sheets with a larger number of bar codes in parallel Disable the human readable text in the bar code if you don t need it saves resources Fora higher number of bar codes use our TFORMer label and form printing software 6 3 6 Known Issues Excel Add In Linked cell bar codes are not resized enlarged automatically when the data content of the linked cell is changed If you receive an error Barcode does not fit into bounding rectangle you have to enlarge the bar code manually In order to update the bar code size of all bar codes in the actual sheet you can use the Redraw all Barcodes function We have seen problems with complex Excel documents having more than 600 bar codes Reaction becomes slow and also crashes can occur This behavior is by design of Excel Embedded Excel sheets in Word may not open if the Redraw on open option is active see 5 2 3 6 3 6 1 Resizing Issues The following issues occur with TBarCode Office V10 5 2 Excel Add In and earlier Sharing Excel documents amon
72. t TBarCode Office in our videos hosted on YouTube http www youtube com view_play list p 1E807C6F1590D866 6 1 Operations Common for Word and Excel 6 1 1 Inserting a Barcode There are different ways for adding a barcode to your document 6 1 1 1 Using the Insert Button To insert a barcode use the button nsert Barcode in the panel See Figure 2 6 1 1 2 Using the Insert Tab Click the nsert tab in the Ribbon and choose nsert Barcode The barcode is inserted at the actual cursor position immediately The settings of the last inserted bar code are applied 6 1 1 3 Using the Add Ins Tab For inserting a barcode with this method switch to the Add ns tab and click Insert Barcode in the Ribbon 6 1 2 Updating a Barcode Open the panel see 5 1 and select the barcode which should be configured If you change the bar code settings in the Panel the barcode is updated immediately 6 1 3 Deleting a Barcode Select the barcode that you want to delete and then press the Del key 6 1 4 Loading a Template Click on the templates icon in the upper right corner A list with templates is displayed Select a template and click OK or click Select from File and select a bc file to load WWW TEC IT COM Page 14 of 60 6 2 Microsoft Word 6 2 1 Create Mailings The TBarCode Office add in for Microsoft Word encodes mail merge fields directly in the barcode Please follow these steps Start with a new Word document A
73. t express authority is strictly forbidden F r dieses Dokument und den darin dargestellten Gegenstand behalten wir uns alle Rechte vor Vervielf ltigung Bekanntgabe an Dritte oder Verwendung au erhalb des vereinbarten Zweckes sind nicht gestattet 1998 2015 TEC IT Datenverarbeitung GmbH Hans Wagner Str 6 A 4400 Austria t 43 0 7252 72720 f 43 0 7252 72720 77 http www tec it com WWW TEC IT COM Page 6 of 60 3 Introduction 3 1 What is TBarCode Office TBarCode Office is a barcode add in which integrates seamlessly into Microsoft Word and Microsoft Excel Microsoft Office 2007 2010 2013 and 2016 are supported This add in allows you to insert all barcode symbologies into Word documents and Excel workbooks with just a few clicks In addition TBarCode Office supports the creation of mailings bar code labels and serial letters by embedding mail merge fields directly into bar codes Thanks to the intuitive user interface this barcode add in is very easy to use Programming skills are not needed TBarCode Office supports more than 100 different barcode variants Among them are linear and 2D symbologies like Code128 Code39 GS1 EAN UPC GS1 EAN 128 Data Matrix QR Code PDF417 Aztec Code and GS1 DataBar The generated barcodes can be printed with all printers The bar codes are created in the highest possible quality Additional printer extensions or barcode fonts are not required TBarCode
74. tandard You can also select a custom template file created with Barcode Studio Select a Template lt Select one of these templates to create a barcode which is compliant to the listed standards You can also create your own templates with Barcode Studio Click here to download Barcode Studio Deutsche Post Premiumadress 2 Data Matrix 22x22 Data Matrix 26x26 W Deutsche Post Pressepost Etikett Data Matrix 52x52 Deutsche Post Pressepost Randbeschriftung Data Matrix 16x48 Data Matrix 52x52 EAN 13 SCO 82 30 51 x 21 25 mm SC1 90 33 9 x 23 32 mm SC2 100 37 29 x 25 91 mm SC2 11N AN FR x IR EN mm Select from File Cancel Figure 6 Templates complying with various barcode standards gt You don t have to purchase Barcode Studio to create a custom template Download the demo adjust barcode properties and save the bc file to a common location Barcode Studio does not save the size mode module width fit to bounding box in a bc file You have to adjust this directly in the TBarCode panel Barcode Studio does not save the draw mode option in a bc file If you want to set a different draw mode you have to set it in the barcode settings WWW TEC IT COM Page 13 of 60 6 Using TBarCode Office This chapter introduces the TBarCode Office add in and explains how to use barcodes in a documents mailings or spreadsheets Check out and learn more abou
75. the bar code size warning you can slightly enlarge the bar code e g drag with the mouse before you start the mail merge WWW TEC IT COM Page 16 of 60 6 2 2 1 Resulting Labels Labels10 Word m 2 Insert Design Layout References Mailings Review View Add Ins Design Layout t Sign in gA d z Emy P Find 5 4 A in Calibri Body 11 Aa als 21 T aapbcene aaBbceoe AaBbCc Aasbcr AaB ER Sac Replace Paste 2 af lt tS is gt sie g B 7 U ab x A V A H T Normal T No Spac Heading1 Heading 2 Title N Select Clipboard amp Font Ir Paragraph G Styles Ir Editing A 1 234567 890128 1 234567 890135 TBarCode SDK TBarCode Office 1 234657 890144 1 234567 890159 TBarCode SAPwin TBarCode X 1 234567 890166 1 234567 890173 Pagelofi Line1 S9words German Austria 5 EE H 100 Figure 9 Barcode Label Printing WWW TEC IT COM Page 17 of 60 6 2 3 Insert Document Properties TBarCode Office Word Add In supports placeholders for document properties which are automatically resolved before printing In order to insert document properties into a bar code follow these steps Start with a new Word document Open the panel see 5 1 Select a barcode type and enter the barcode data Use the Insert Fields button in the panel to bring up the selection of available merge fields and document properties Inthe Properties tab s
76. ther cells labels Click Finish amp Merge See ie Document4 Word I m 0 x File Home Insert Design References Mailings Review View Add Ins Design T e a Sign in 2 Share Envelopes Labels Start Mail Select Edit Highlight Address Greeting Insert Merge Create Start Mail Merge Write amp Insert Fields EE MEERDE EE BP 2 EB A Bea pme her ME as Match Fields D Find Recipient Preview Finish amp Merger Recipients Recipient List Merge Fields Block Line Field 27 Labels Results 2 Check for Errors Merge Preview Results Finish a TBarCod office Er Next Record Barcode EINS B Data 80 EAN_Code 234567 890180 234567 8901 Product_Name Product_Name Insert Fields Next Record Next Record Size Fit into Bounding Box Module Width auto Width 44 379 1 234567 890180 1 234567 890180 Height 26 194 Product_Name Product_Name Size in mm Page1of1 Line 1 22words German Austria 1 E3 Next Record Next Record Insert Barcode 1 2345 N 4567 R9018 234567 RAN1RI Barcode Settings m 6 1 8 S Figure 8 Barcode Label Printing gt gt If you change something in the first label e g the bar code size please click Update Labels in the Mailings tab to update the remaining labels bar codes on the page To avoid
77. tion in 0 90 IV Default Structured append Use structured append Number of symbols A Z A Index of this symbol A Z a Message ID optional Cancel Figure 21 Advanced Properties Aztec Code 7 8 1 Format Format Specifier You can choose from Value Description Default The standard format of Aztec Code UCC EAN GS1 Special format defined by GS1 UCC EAN Used for encoding so called Application Identifiers FNC1 is added at first position Industry For special industry formats If you choose this value you have to fill in a Format Specifier 2 digits or 1 letter It determines which industry format the barcode data corresponds to FNC1 is inserted at second position 7 8 2 Symbol Size Defines the size of the Aztec Code symbol Possible values range from 1 15 x 15 to 33 151 x 151 modules If the property is set to default the size is computed automatically based on the length of the barcode data Additionally you can select one of three reader mode 19x19 reader 23x23 reader 27x27 reader These modes are often used to program the barcode scanners 7 8 3 Enforce binary encoding If checked binary mode is used for encoding no input data analysis This mode is recommended if you want to encode binary input data 7 8 4 Enable Aztec Runes The Aztec Runes mode is a special mode of the Aztec Code You can encode only values between 0 and 255
78. to a document TBarCode Office does not distinguish between standard custom or server properties all are referenced by the same placeholder format 8 Support for document properties has been added in version 10 5 3 for server properties you need 10 5 4 or later 9 This behavior may be changed or made be configurable in a later version 10 Available via Microsoft Sharepoint server WWW TEC IT COM Page 18 of 60 Placeholders for document properties are resolved in the following order 1 Search in standard properties 2 Not found gt Search in custom properties 3 Not found gt Search in content type server properties The document properties are updated in the bar codes immediately before printing On the other hand saving the document as PDF or emailing the document will not update the bar codes gt The Word function Save amp Send does not refresh document properties in the bar codes gt You can turn off encoding document properties in the add in options 6 2 4 Reference Content Controls Legacy Form Fields and Bookmarks TBarCode Office Word Add In supports placeholders for referencing content controls and legacy form fields either via Tag or Bookmark The placeholders are automatically resolved before printing which means the actual value of the control will be populated into the bar code TBarCode Office as AR Ti EKG re Content Control Properties Barcode General Code 12
79. tore the original input data Decompression can be done through the TBarCode InForm software decoder which restores the uncompressed data automatically Or you can use any third party software library for decompression 7 2 9 Suppress Error Messages If the barcode data contains invalid characters e g letters for code 2 of 5 Interleaved or if the wrong number of input characters is provided an error message is displayed instead of the bar code If Suppress error message is enabled this error message will be suppressed Only blank space is displayed instead of any error information 7 2 10 Translate Escape Sequences Selects whether escape sequences like n are translated or not default no The use of escape sequences is useful if you need to encode control characters such as Carriage Return or FNC1 For encoding binary data e g Data Matrix this feature may be very useful as well For more information on escape sequences please refer to the Barcode Reference see Appendix A 7 2 11 Button License Opens the license dialog For more information on how to license the product please refer to chapter 8 7 2 12 Button About Opens the about dialog The About dialog shows the product version and copyright information to the user WWW TEC IT COM Page 29 of 60 7 3 Property Page Appearance TBarCode10 Properties d es Barcode Appearance Multiple Barcodes Font Color
80. x Code Formats 7 10 2 Symbol Size Defines the size of the symbol in terms of rows and columns Possible sizes are 10 x 10 to 144 x 144 modules for a square symbol and 8 x 18 to 16 x 48 for a rectangular symbol When set to default the minimal square size is used depending on input data 7 10 3 Show as Rectangle Determines if the Data Matrix symbol should be displayed as rectangle checked or square unchecked default 7 10 4 Structured Append If you want to connect several Data Matrix symbols in order to encode larger quantities of data you can use Structured Append WWW TEC IT COM Page 42 of 60 7 10 4 1 Use structured append Activates structured append symbol chaining with this option 7 10 4 2 Number of all symbols 2 16 Enter the total number of chained Data Matrix symbols here A maximum of 16 symbols may be used within one chain 7 10 4 3 Index of this symbol 1 16 A symbol identification number which is entered in the index field must be assigned to each Data Matrix symbol Its value can range from 1 to 16 This index indicates the order in which the data is joined after the reading scanning process 7 10 4 4 File ID 1 64516 The File ID has to be the same for all symbols within a chain WWW TEC IT COM Page 43 of 60 7 11 Adjust Properties MaxiCode MaxiCode represents data by drawing hexagonal items which are arranged around a circular center bull s eye The

TBarCode Office User Manual V10.7

Contents

Download Pdf Manuals

Related Search

Related Contents