Printing Each Row

[Tinker B]

Hello,

I have a contact document in Microsoft Word that has information such as a person name, address, and contact number.

In Excel, in Column A, I have a multiple names such as Bob on A1, Steve on A2, Joe on A3, and Berth on A4.
In Column B, I have their address.
In Column C, I have their contact number.

My question is, how do transfer ROW 1 (i.e., Bob's information: Name (A1), Address (B1), and Contact number(C1)) from Excel to Word and Print. Once ROW 1 information is printed in Word, it will print ROW 2 information, and so on until the last row.

I know how to transfer data from excel to word using Bookmark but how do I grab data from each row and print each row information individually?

Thank you for your help,
Tinker B

 

[Andrew Poulsom]

You can use Mail Merge. Here's how:

Mail merge using an Excel spreadsheet - Word