Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bonnie K - 17 Oct 2004 15:49 GMT
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- - 31 Oct 2004 11:05 GMT
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
[quoted text clipped - 13 lines]
> 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 :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.