Microsoft Office Tutorials and References
In Depth Information
Reviewing Data File Formats
Excel Files (*.xlsx, *.xlsm, *.xlsb, *.xls)
Web Pages (*.htm, *.html, *.asp, *.mht, *.mhtml)
Rich Text Format (*.rtf)
Word Documents (*.docx, *.doc, *.docm, *.dot)
Text Files (*.txt, *.prn, *.csv, *.tab, *.asc)
Database Queries (*.dqy, *.rqy)
OpenDocument Text Files (*.odt)
Several older i le formats are not directly supported in Word 2013, including Microsoft Works Databases ( *.wdb ),
Outlook Personal Address Books ( *.pab ), Lotus 1-2-3 i les ( *.wk? , *.wj? ), Paradox i les ( *.db ), and dBASE
i les ( *.dbf ). Note that if you still have the old software, you can often export from those formats to a delimited
*.txt or *.csv i le that you can then use for the merge.
Using most of the data source formats works in a similar fashion, so there’s no need to go
through each and every type in detail. However, this chapter will cover the most
common formats. Keep in mind that although the chapter examples repeatedly use names and
addresses, you’re by no means limited to those. Your list could be a list of products, an
inventory, planetary information for a school project, and more. The idea is to use Word to
present and format data in some fashion; it doesn’t matter to Word what the data pertains to.
To begin, on the Mailings tab in the Start Mail Merge group, click the Select Recipients tool,
exposing the options shown in Figure 10.1.
When selecting a data ﬁ le, you can create it from Word, use a variety of other formats, or
select data from Outlook Contacts.
This section explains how to set up the various types of data source i les. You’fill learn how to attach the data source
during the merge process later in the chapter.