Hi, I am running Office 2003 and need some help getting started with a project.



I have an excel workbook with 4 columns of data and anywhere between 1 and 100 rows. The columns have headers for LastName, FirstName, DOB, and PhoneNumber. The entries begin in row 2.

In word, I need to import that data so that I can print it in the following format:

Last Name: Doe, First Name: John, DOB: 040581, Phone Number: 5025551212

where Doe, John, 040581 and 5022221212 appear in cells a2, b2, c2 and d2.

Each entry needs to be on a separate page. I need the macro to recognize how many rows on the worksheet actually have data, and only import that data, and provide that same number of pages.

Hopefully, I explained this so that it makes sense. Can anyone help me.

Soma