View Single Post
  #8   Report Post  
Sheri Wood Sheri Wood is offline
Junior Member
 
Posts: 1
Cool

Quote:
Originally Posted by View Post
This is a simple question but I can't remember how to do this. First
of all I am using Microsoft Word 2003. What I am trying to do is a
mail merge from an excel worksheet. Normally I have no problems doing
this but unfortunately the worksheet I was given does not have the
Title row as the first row instead the Title row is on the second row.

When I select the recipient list I go "browse" then I select the Excel
worksheet and I make sure to uncheck the box that says "First row of
data contains header columns". But the mail merge is still picking up
the first row as the title of the columns.

How do I change the mail merge so that it picks up the second row as
the column titles?

Thanks in advance
Lee
Leatrice,

Just select the row that you want to use as the header as a filter. Then when you select your sheet to be used in the drop down. You should see "spreadsheet_name_filter" in some configuration.

You then just select that sheet and you only have the information from the headers down or filtered headers down.

Sheri.