How do I add another field in a mail merge linked to an excel spr.

[Bonnie K]

I'm trying to print a list of mailing labels using mail merge in Word, taking
data from a very detailed Excel spreadsheet. This is currently set up with
data elements for Name, Organizaion, Address, etc., and I want to add one
more element to the address -- the position title corresponding to the name
(e.g., John Smith, President).

When I go through the steps to set up the mail merge document, I'm clicking
on the option to use an existing list, and then I get a menu to select a
table, and then a list of data elements that don't include the other
elements, but not the positon title.

How do I change the table so that the position title is another field I can
add to the address block?

The labels for the data elements in the spreadsheet are in Row 13, not at
the top, and they are correspondingly labeled in the table when I get that
box to appear in Word, but, as I've said, the position title is not included.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Qm9ubmllIEs=?=,

Which version ofn Word are we discussing? If you've added Position Title at the
end of the list of fields (new column) it's likely that the data range that's
been marked for the mail merge simply isn't including this column. If you
move+insert the column into the existing table, does anything change?

If not, try selecting the entire table and assigning a RANGE NAME to it. Then
start setting up the mail merge again, linking to the data source, and choosing
this name.

I'm trying to print a list of mailing labels using mail merge in Word, taking
data from a very detailed Excel spreadsheet. This is currently set up with
data elements for Name, Organizaion, Address, etc., and I want to add one
more element to the address -- the position title corresponding to the name
(e.g., John Smith, President).

When I go through the steps to set up the mail merge document, I'm clicking
on the option to use an existing list, and then I get a menu to select a
table, and then a list of data elements that don't include the other
elements, but not the positon title.

How do I change the table so that the position title is another field I can
add to the address block?

The labels for the data elements in the spreadsheet are in Row 13, not at
the top, and they are correspondingly labeled in the table when I get that
box to appear in Word, but, as I've said, the position title is not included.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail