How to Insert Merge Fields in Word from Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

dataset for how to insert merge fields in word from excel

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.

Paste Special feature how to insert merge fields in word from excel

  • 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.

Single merged field Paste Special feature how to insert merge fields in word from excel

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.

Multiple merged field Paste Special feature how to insert merge fields in word from excel

  • 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.

Multiple merged field Paste Special feature how to insert merge fields in word from excel

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.

Multiple merged field Paste Special feature how to insert merge fields in word from excel

  • 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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Akib Bin Rashid
Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo