Extracting data from excel sheet to word

[p86c]

So - I have a sheet in excel with 200 named clients in the left hand column and 50 products in the top row.
Each client may/may not have ordered a number of each product and this number is recorded in the appropriate cell.

I would like to create a sheet in word that displays just one client's information per page.

ie it shows the client name and then how many of each product they have ordered.

It would be nice if only the products ordered showed up but I could live with blanks for the products that are not ordered.

I was hoping that someone might point me in the right direction to tackle this task.

 

[Trevor G]

You could set this up in Word by using MailMerge.

 

[p86c]

You could set this up in Word by using MailMerge.

Thanks Trevor - that gives me a direction to examine.

 

[Trevor G]

Hope it helps you find a solution.