View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Matt

Select data rows starting at header row and below.

Give this a range name. InsertNameDefine.

When in Word, browse to the file and you will be able to select the range by
name.

That range will be the merge range and will ignore the rows above.

Gord Dibben Excel MVP

On Thu, 2 Dec 2004 14:39:09 -0800, "MATT"
wrote:

I would like to create a Form Letter, importing data from an Excel Spread
Sheet. On the first few rows of the Excel Spread Sheet is some data not to
be moved, and several rows below the first row is the header row. Of course,
when I go to merge into the document, the fields are not there because it is
reading from Row 1. Is there a way to specify that the header row is Row
"x", thus ignoring the rows above?
Thank you