Mail Merge - Header Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Matt

Select data rows starting at header row and below.

Give this a range name. Insert>Name>Define.

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access Page Header with merge field 0
Showing Letters For Column Headers Rather Thann Numbers ? 1
How do I add rows and headers to several worksheets automatically 1
Mail Merge 1
Header rows 4
writing a sort macro 2
In Excel, use a different row for headings (not row 1) 1

Back
Top