Mail Merge - Header Row
 

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

Hi
AFAIK not possible. Any chance you can use a separate sheet with the
copied data?

--
Regards
Frank Kabel
Frankfurt, Germany

"MATT" schrieb im Newsbeitrag
...
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

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