Convert excel rows into individual documents in word
 

Hi,

Any help would be great for the following please:

I have an excel spreadsheet which contains employee records - I want
to be able to view and print individual records but only the fields
that are populated for example:

Excel:

Emp No Name DOB Department Grade
12345 Joe 28/02/78 Finance
67890 Ian E5
11122 24/11/81 HR

I want to be able to print and view these records separately ie:

Emp No 12345
Name Joe
DOB 28/02/78
Department Finance

Emp No 67890
Name Ian
Grade E5

Emp No 11122
DOB 24/11/81
Department HR

Any ideas?

Thankyou

Rachel