Microsoft Office Tutorials and References
In Depth Information
Word and text files
Headerless data files
After you attach a data source ﬁ 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 ﬁ rst row of data contains the column headers. If your data source
ﬁ le doesn’t include column headers in the ﬁ rst data record, you’fill run into problems, as
shown in the Mail Merge Recipients dialog box in Figure 10.7. And if a ﬁ eld in the top
record is empty, Word displays AutoMergeField as the ﬁ eld title.
Beware of data ﬁ 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 ﬁ le.
Understanding delimited files
Figure 10.8 shows a comma-separated value ( *.csv ) ﬁ le opened in Word. The ﬁ rst row has
the ﬁ eld names separated by commas, and each subsequent row contains one record, with
the record’s ﬁ eld entries separated by commas. Note that if a ﬁ eld is empty, two commas
appear to keep the ﬁ elds properly synchronized. When you attach a delimited ﬁ le, you may
be prompted to convert the ﬁ le and conﬁ rm the encoding to use. In most cases, you can
simply click OK to continue.