Thanks alot. I knew what I wanted but I couldn't remember the
function/operator.

Got another one (also posted as a new question here in Excel):
How do you capture an image in a cell? I have images that I want to
associated with the record. Also for ecport through Mailmerge to Word.

"Earl Kiosterud" wrote:

jbrzez,

Use the Mail Merge feature in Word. Exactly what you need. Use the Excel
list as the data source. After having set it up and run the merge, you can
run it again later when the Excel data has changed for a new set of pages.
There's a query capability to only produce pages for the records (rows in
the Excel sheet) you want, based on date, etc. For additional questions,
post in the Word group.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"jbrzez" wrote in message
...
I have a Family directory in Excel (first name field, Last Name, email,
etc.). I need to create a report in some Office product (I would assume
Word) that allows me to create a new page for each row and places the data
on
the new page in the same format/layout for each row of data. ANY help
would
be appreciated.