New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share

How do I create and Mail Merge Intelligent Mail Barcodes using Excel and Word?




06-05-12     3638 day(s) ago    

  Report Abuse

 

Ben

Best Answer

Once you have installed the barcode fonts and Add In, you will be able to use
the Add In to encode data in Excel. Are you able to see the Add in tab? If not,
please view the article regarding the Add In Visibility.

1. You can enter the data in a column (Example Column A) and duplicate the
A column in Column B:

image


2. Duplicated, Column B can be the barcode Column for the Add In/
Intelligent Mail Barcode:

image


3. Apply the Add in by selecting the data in Column B then choose Add-Ins,
select Intelligent Mail from the drop down, and select Change To Barcode:

image


You will see the Barcode column as an Intelligent Mail Barcode. The next
step is to save the file and perform a mail merge. Once the merge is
performed, you will need to re-apply the font to the merged field. If you do
not know how to perform a Mail Merge, please
visit
Microsoft's Office site for instructions.
image


Apply the IDAutomationIMB or IDAutomationPOSTNET font (this font must be applied to
Intelligent Mail encoding) to the merged field <<Barcode>>

image


This is what the field will look like with the IDAutomationIMB or IDAutomationPOSTNET font
applied:

image


Preview of the document includes a field with the original data and the
barcode field:

image

Posted 3638 day(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (1)
I just knew that your product could achieve this.

Posted 3603 day(s) ago

(0)
(0)
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

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

 © Copyright 2021 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook