Excel Data Sourch Setup for Merge
 

My question has to do with using Excel as a data source for a merge. The
first 10 rows I entered common data and hid the columns (intending for the
ease of data entry to auto-populate or pick from a list). Obvioiusly, when I
choose to merge after entering data into mulitple 'shown' rows, it wants to
merge the first 10. I want to know if Excel and Word can talk to each other
and exclude these hidden rows if there is a qualifier in a cell that will
make it "skip over" it in a sense. If not, I understand that you can choose
what data to merge within Word, but would rather not have to do this to save
some steps OR have to create programming for it since we do plan to have a
database program by EOY that will handle these fields.