Other database files To access other kinds of data sources, you'll run the Data Connection Wizard: For more information, see Use mail merge to send Access data to Word. For more information, see Prepare your Excel data source for a Word mail merge.Īccess database With Access, you can select data from any table or query defined in the database. Important: No matter what type of file you use as a data source, be sure to save it on your local computer or a file share saving at an HTTP location isn't supported for mail merge.Įxcel spreadsheet An Excel spreadsheet works well as a data source for mail merge if all data is well-formatted and on one sheet so that it can be read by Word.
