Microsoft Office Tutorials and References
In Depth Information
Word and text files
Headerless data files
After you attach a data source fi le, you can check it by clicking Edit Recipient List in the
Start Mail Merge group of the Mailings tab. (You’fill learn more about editing a data source
later in the chapter.)
Word assumes that the fi rst row of data contains the column headers. If your data source
fi le doesn’t include column headers in the fi rst data record, you’fill run into problems, as
shown in the Mail Merge Recipients dialog box in Figure 10.7. And if a fi eld in the top
record is empty, Word displays AutoMergeField as the fi eld title.
FIGURE 10.7
Beware of data fi les that don’t contain a header row!
If the recipient list doesn’t look as expected, click OK to close the Mail Merge Recipients
dialog box. Open your data source document, and add the missing header row. Then return
to the main document and reattach the fi le.
Understanding delimited files
Figure 10.8 shows a comma-separated value ( *.csv ) fi le opened in Word. The fi rst row has
the fi eld names separated by commas, and each subsequent row contains one record, with
the record’s fi eld entries separated by commas. Note that if a fi eld is empty, two commas
appear to keep the fi elds properly synchronized. When you attach a delimited fi le, you may
be prompted to convert the fi le and confi rm the encoding to use. In most cases, you can
simply click OK to continue.
10
Search JabSto ::




Custom Search