Mail Merge
 

I'm trying to create a mail merge document in Microsoft Word that takes the
information from an existing Microsoft Excel spreadsheet. I've never done
mail merge before, so i am very unfamiliar with it. When i follow the
instructions, i get to a point where i have to browse for recepients using an
existing list. Once i click on the excel document i want, a window comes up
that says select table. That's fine. But in this window it has a box to check
off "first row of data contains column headers", and my column titles are in
the SECOND row. The first row has titles such as "demographics",
"scheduling", "results"...etc. but the second row has the individual titles i
need like "first name" and "last name". Is there any way to tell it to use
the second row for the column titles? Thanks.

Mail Merge
 

Never mind! Figured it out from reading someone else's post!

"Shannan" wrote:

I'm trying to create a mail merge document in Microsoft Word that takes the
information from an existing Microsoft Excel spreadsheet. I've never done
mail merge before, so i am very unfamiliar with it. When i follow the
instructions, i get to a point where i have to browse for recepients using an
existing list. Once i click on the excel document i want, a window comes up
that says select table. That's fine. But in this window it has a box to check
off "first row of data contains column headers", and my column titles are in
the SECOND row. The first row has titles such as "demographics",
"scheduling", "results"...etc. but the second row has the individual titles i
need like "first name" and "last name". Is there any way to tell it to use
the second row for the column titles? Thanks.

Mail Merge
 

Select A2 and scroll down and across to select the range of data.

Give this range a name like mymaildata.

Word's mailmerge will accept that name in "select a table"

See these sites for very good help with mailmerge.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Wed, 25 Nov 2009 14:32:01 -0800, Shannan
wrote:

I'm trying to create a mail merge document in Microsoft Word that takes the
information from an existing Microsoft Excel spreadsheet. I've never done
mail merge before, so i am very unfamiliar with it. When i follow the
instructions, i get to a point where i have to browse for recepients using an
existing list. Once i click on the excel document i want, a window comes up
that says select table. That's fine. But in this window it has a box to check
off "first row of data contains column headers", and my column titles are in
the SECOND row. The first row has titles such as "demographics",
"scheduling", "results"...etc. but the second row has the individual titles i
need like "first name" and "last name". Is there any way to tell it to use
the second row for the column titles? Thanks.