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

Hi soma,

Use a mailmerge in Word. It's easy to set up and will do exactly what you've asked for. No macros required. And, if you change the amount of data, re-running the mailmerge will give you an new output. You can even specify which records to include/exclude.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]