Convert excel rows into individual documents in word

[Rachel Curran]

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

 

[Doug Robbins - Word MVP]

Create a userform with list box that is loaded with the records from Excel
and then have a command button on the form that populates the document with
the data for the person selected in the list box

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and "Load a ListBox from a Named Range in Excel using DAO" at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP