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.
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.
Read More: How to Make Address Labels in Word from Excel
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.
Read More: How to Mail Merge from Excel to Word Envelopes
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.
Read More: How to Mail Merge Pictures from Excel to Word
Things to Remember
- If you want to transfer data from Excel to Word, you can also try the copy-and-paste methods.
Download Workbook
You can download the Excel and Word files used in this article from here.
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.