How to Insert Merge Fields in Word from Excel

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I will show you how to insert merge fields in Word from Excel.

Table of Contents hide

2 Suitable Ways to Insert Merge Fields in Word from Excel

1. Using Paste Special Feature to Insert Merge Fields in Word from Excel

1.1 Single Merged Field

1.2 Multiple Merged Field

2. Applying Keyboard Shortcut to Insert Merge Fields in Word from Excel

Things to Remember

Conclusion

2 Suitable Ways to Insert Merge Fields in Word from Excel

This is the dataset that I am going to use for today’s article. I have a list of authors and they are in merged fields.

I will use this dataset and explain 2 ways to insert merge fields in Word from Excel.

1. Using Paste Special Feature to Insert Merge Fields in Word from Excel

The first method is the use of the Paste Special feature to insert merged fields. You can apply this feature for both single merged fields and multiple merged fields. Let’s see them one by one.

1.1 Single Merged Field

First, I will show the case for a single merged field.

Steps:

First of all, select the field you want to insert in Word.
Then, right-click your mouse to bring the context menu.
After that, click Copy.

Then, open a Word.
After that, go to the Home tab of that Word.
Then, go to the Paste.
After that, select Paste Special from the drop-down.

The Paste Special window will appear.
Select Microsoft Excel Worksheet Object as the type.
Then, click OK.

Excel will insert a single merged field in Microsoft Word.

1.2 Multiple Merged Field

Next, I will show how you can insert multiple merged fields in Word. This is almost the same as the previous method.

Steps:

First of all, select the fields you want to insert in Word.
Then, right-click your mouse to bring the context menu.
After that, click Copy.

Then, open a Word.
After that, go to the Home tab of that Word.
Then, go to the Paste.
After that, select Paste Special from the drop-down.

The Paste Special window will appear.
Select Microsoft Excel Worksheet Object as the type.
Then, click OK.

Excel will insert a single merged field in Microsoft Word.

Similar Readings

2. Applying Keyboard Shortcut to Insert Merge Fields in Word from Excel

Now, I will show you how you can apply some keyboard shortcuts to insert merge fields in Word from Excel.

Steps:

First of all, select the fields you want to insert in Word.
Then, press the keyboard shortcut CTRL+C to copy the fields.

Then, open a Word
After that, go to the Home tab of that Word
Then, go to the Paste
After that, select Paste Special from the drop-down.

The Paste Special window will appear.
Select Microsoft Excel Worksheet Object as the type.
Then, click OK.

Excel will insert a single merged field in Microsoft Word.

Things to Remember

If you want to transfer data from Excel to Word, you can also try the copy-and-paste methods.

Conclusion

In this article, I have demonstrated 2 effective ways on how to insert merged fields in Word from Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.