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.