Knowledge Base

Formatting Data in a Print Merge in Works for Windows

Article ID: 103677

Article Last Modified on 11/24/2003

APPLIES TO

This article was previously published under Q103677

SUMMARY

When you merge data from a Works database to a Word Processing file, the data coming from the database is represented by a placeholder with the name of the field. Character formats in a database document are not transferred into the merged document. You can format merged data to a particular font, style, or size by formatting the placeholder. For example, to format the names of companies as bold, format the company placeholder in the word processing document as bold.

You can also align numeric data in columns using custom tab settings. Using the SPACEBAR or the default tabs may cause misalignment of the merged numeric data.

MORE INFORMATION

The following two methods can be used to align numeric data:

  1. Set a decimal tab at the position where you want the decimal points in the data to line up.

    Using the TAB key, move the placeholders to the decimal tab setting. (The placeholders will align to the left of the tab setting.)

    If the field names are different sizes, the placeholders will appear out of alignment. This does not affect the positioning of the merged data.
  2. If the numeric data contains a fixed number of digits after the decimal point for example, currency with cents after the decimal point, a right-aligned tab may be set for the column of placeholders instead of a decimal tab.

How to Set Custom Tabs in Works

  1. Select the paragraph in which you want a tab stop.
  2. On the Format menu, click Tabs.
  3. In the Position box, type the position you want for the tab stop.
  4. Under Alignment and Leader, select the options you want.
  5. Click the Set button (click Insert in Works versions 3.0 and 2.0).
  6. Repeat steps 3 through 5 to insert as many tab stops as you want.
  7. Click OK.

Additional query words: wp db merging combining italic underline form letters mailing labels information place holders w_works wworkskb lab env formlet fmt pm

Keywords: kbhowto KB103677


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.