In Microsoft Word, how do I create a mail merge document using 2 different data sources?

Answer 1

It's not possible in Word. You can only use one source. You will need to combine the two sources prior to doing the mail merge. There may be some options for you though if the source files are either Excel or Access.

If the source files are in Access, create a query joining the two data sources. When doing the mail merge, access the query you created.

If the source files are in Excel and you also have Access, you can combine them using a query. Link the Excel sheets to an Access database. Create a query joining the two data sources. When doing the mail merge, access the query you created.

This method will enable you to re-run this again in the future as well. If you make changes/corrections to the excel spreadsheet, they will be reflected if you re-run the mail merge.

Answer 2

1) Can you combine the 2 data sources into 1 before you enter the mail merge?

2) Use the Mail Merge Wizard. When you get to step 6 and print, just keep hitting the Previous link at the bottom of the pane(s) until you get back to the select recipients pane and browse to the second data source. Then go forward thru the Mail Merge Wizard using this new data source.

Answer 3

I dont think you can use 2 different data sources, i've been doing mail merge all day and havent seen an option to include a secondary data file, you may have to just mail merge each file seperately.