University of North Texas Computer Advantage Program
Advanced Word 97 - MailMerge It Together
| I want merged text and numbers to have different formatting. | Merged information has the character formats
you apply to the merge fields in the main document. The formatting in the data source has
no effect.
|
|
| When I open a document, Word asks me to locate a data source. | After you select a data source for a main
document, Word looks for the data each time you open the main document. If you no longer
use a document as a mail-merge main document, you can remove its associated data source. Remove the associated data source from a main document
|
|
| Merge fields are printed instead of my data. | On the Tools menu, click Options, and then
clear the Field codes check box on the Print tab. With the main document active, click
Merge to Printer on the Mail Merge toolbar. Note Do not try to print the form letters by using the Print command (File menu) unless you have first collected the resulting merged documents in a new document. Return to MailMerge Table of Contents |
|
| I get a message saying that my data file is a mail-merge main document. | The data source was the active document when
you chose the Mail Merge command (Tools menu), so it was accidentally selected as the main
document. Use the following procedure to remove the main-document designation.
|
|
| I want to use mail merge for something other than a form letter. | To combine any type of "standard"
text with unique information listed in a separate file, follow the instructions for form
letters. You can use this basic process to create legal documents, contracts, and many
other types of documents. To print a list of information from a database -- such as a parts list, membership directory, or catalog -- follow the instructions for catalog main documents. |
|
| Create a catalog, membership directory, parts list, or similar document | If you select Catalog as the type of main
document, all of the merged data is placed in one resulting merged document. Any standard
text you add to the main document is repeated for each set of data.
|
|
| I want to create a data source first, before I start a mail-merge document. | The easiest way to create a data source in Word
is to use the Mail Merge command to start a main document. After you've created the data
source, you can delete the blank main document. In a new document window, click Mail Merge (Tools menu), click Create, and then click Form Letters. When Word displays a message, click Active Window. Then click Get Data and create a data source. |
|
| I changed label or envelope size. How do I fix my main document? | To change the size or other aspects of an
envelope main document, or if you change printers, open the envelope main document, and
then click Envelopes and Labels (Tools menu). In the Envelopes and Labels dialog box,
select the envelope options you want. To change mailing labels, click Mail Merge on the Tools menu, and then create a new mailing labels main document In the Label Options dialog box, select the type of printer and the type of labels you want to use. If your label type is not listed, you can create a custom label size. |
|
| Create custom mailing labels | If the brand of labels you want to use is not
listed in the Product number box (Label Options dialog box), you may be able to use one of
the listed labels, or you can create your own custom labels.
The new label appears in the Product number box as "Label name - Custom,". Note Measure the labels carefully. The label size indicated by the label manufacturer may be slightly smaller than the actual size. For example, a 1-by-2-inch label might actually be 15/16-inch high and 1-15/16-inches wide. In the Create Labels dialog box, insert the merge fields for the address information. Tips for inserting address merge fields
|
|
| Blank lines are showing in the merged documents. | If unwanted blank lines appear in addresses or
similar information, make sure that Don't print blank lines when data fields are empty is
selected in the Merge dialog box. To prevent blanks lines with Word fields such as IF,
SET, and ASK, do the following:
{ IF { MERGEFIELD Product } = "Pasta" "We have expanded our line of pasta products. Please see the enclosed brochure.¶ " " " } Thank you for your order.¶ |
|
| I selected the option to merge form letters to a new document. How do I print specific letters? | When you merge form letters or similar types of
merged documents to a new document, Word places each letter in a separate section of the
new document. To print only specific letters from the new document, click Print on the File menu. In the Pages box, type the numbers of the sections that contain the letters you want to print. For example, to print the third, sixth, seventh, and eighth form letters, type s3,s6-s8 in the Pages box. To identify the section number, click a letter and then note the section number displayed at the bottom of the window; for example, "Sec 3." |
|
| Can I use main documents I created in other versions of Word? | You can use main documents you created in Word
version 7.0 as well as in the following other versions of Word:
To merge the documents, open the main document, and then click Mail Merge on the Tools menu. If necessary, click Get Data and then select the data source. Finally, click Merge. |
|
| IF fields do not compare data fields correctly. | When an IF field compares a data field with the
information you specify in the Insert Word Field dialog box, the capitalization of text is
significant. If you don't know whether text in a data field is in uppercase or lowercase
letters, use a format switch to compare the text as though it had the same capitalization
pattern you type in the Compare To box. In the following example, the (\* Caps) switch instructs Word to compare the Country data field as though each word starts with a capital letter. Insert the format switch in the IF field codes, as shown in the example. { IF {MERGEFIELD Country \* Caps } <> "United Kingdom" "We offer special rates on travel within the British Isles." " " }
|
|
| Use | To compare | |
| \* Upper | All uppercase letters (UNITED KINGDOM) | |
| \* Lower | All lowercase letters (united kingdom) | |
| \* FirstCap | First word with an initial capital letter (United kingdom) | |
| \* Caps | All words with an initial capital letter (United Kingdom) | |
| When I attach a mail-merge data file or insert a database, Word automatically starts the source application to get the data. How can I get the data without starting the source application? | By default, when you insert database
information or attach it as a mail merge data source, Word uses DDE to read the data file.
DDE automatically starts the source program (such as Microsoft Excel) and then opens the
data file. If you don't want to start the source program, you can use ODBC or a file converter instead of DDE to read the data file directly. To do this, insert the database information, or attach it as a mail merge data source as usual. In the Open Data Source dialog box, select the Select method check box before you click Open. Then, each time you insert database information or attach it as a mail merge data source, Word opens the Confirm Data Source dialog box so that you can click the ODBC driver or file converter you want.
|
|
Return to MailMerge Table of Contents
Direct questions regarding this site to the University of North Texas Computing Center Helpdesk. We can be reached by e-mail at helpdesk@unt.edu , or by phone at 940.565.2324. Hours: Sunday 1pm-midnight, Monday-Thursday 8am-midnight, Friday 8am-8pm, Saturday 9am-5pm.
UNT Computing Center - UNT Box 305398 - Denton, TX 76203