Word Mail-Merge when using Access as a data source

Unfortunately, there are no built-in components in Access to apply the formula needed to format the static data appropriately. In Access, this conversion has to be done either before the data is put into the table or using one of IDAutomation's VBA functions when the data is ready to display in an Access form or report. However, in Excel, the data is formatted correctly into another column using the macros and can then be pulled into the mail merge.

There are three options:

1. Print directly from Access by creating an Access Report or use the Access' built-in templates for creating documents & labels as desired. This may be the least flexible approach. IDAutomation has outlined three methods here.

OR
2. Create a simple program, using Visual Basic or the programming language of choice, that would convert the data into the correct format before the data is put in the table. The program would insert the actual data into one column in the table and put the converted data in another column. Once the data is in the table a mail merge could be accomplished in Word by linking to the formatted data column and applying the barcode font to the mail merged field.

OR
3. Otherwise export the Access table to an Excel spreadsheet, because Excel allows for the application of special formulas to the data in the columns. In order to use Excel it requires exporting the data from Access into Excel. The Export wizard will be found in the File menu in Access. Once the data is in Excel, add an additional column to the spreadsheet and follow the tutorial for using custom formulas. Now that the data is formatted properly in Excel, use IDAutomation's mail merge tutorial for finishing the task.

See also:

• Unable to scan data printed with a barcode font
• Microsoft Access or Excel Compile Error: Can't find project or library
• Word Mail-Merge retrieves entire row of data when using Excel as a data source

Keywords: TSI mail merge mail merge merging rows columns access database table

Copyright © 2004-2006, IDAutomation.com, Inc. All rights reserved. All trademarks mentioned are the property of their respective owners.