Can i mail merge in word from multiple excel files

The classic question!

Yes, you can mail merge in Word from multiple Excel files. Here are a few ways to achieve this:

Method 1: Concatenate Excel files into one

1. Open all your Excel files and copy the data you want to merge into a new Excel file.
2. Use the & operator to concatenate the data from each file into a single column. For example, if you have two files with columns A and B, you can create a new column C with the formula =A1&" "&B1.
3. Save the new Excel file with the concatenated data.
4. Open Word and create a new document.
5. Go to the "Mailings" tab and click on "Select Recipients" > "Use an existing list".
6. Browse to the new Excel file and select the concatenated data range.
7. Follow the usual mail merge process to create your document.

Method 2: Use Excel's Power Query feature

1. Open all your Excel files and create a new Excel file.
2. Go to the "Data" tab and click on "From Other Sources" > "From Microsoft Query".
3. In the Query Editor, create a new query by clicking on "New Query" > "From Excel Files".
4. Select the files you want to merge and choose the data ranges you want to merge.
5. Use the "Append" function to concatenate the data from each file.
6. Save the query as a new Excel file.
7. Open Word and create a new document.
8. Go to the "Mailings" tab and click on "Select Recipients" > "Use an existing list".
9. Browse to the new Excel file and select the merged data range.
10. Follow the usual mail merge process to create your document.

Method 3: Use VBA macros in Excel

1. Open all your Excel files and create a new Excel file.
2. Record a VBA macro that concatenates the data from each file into a new worksheet.
3. Save the macro as a new Excel file.
4. Open Word and create a new document.
5. Go to the "Mailings" tab and click on "Select Recipients" > "Use an existing list".
6. Browse to the new Excel file and select the merged data range.
7. Follow the usual mail merge process to create your document.

Method 4: Use a third-party add-in

There are several third-party add-ins available that can help you merge data from multiple Excel files into a single file for mail merging. Some popular options include:

• Excel Merge: A free add-in that allows you to merge data from multiple Excel files.
• Mail Merge Toolkit: A commercial add-in that provides advanced mail merge features, including the ability to merge data from multiple Excel files.

I hope these methods help you achieve your goal!