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 / August 2006

Tip: Looking for answers? Try searching our database.

What is a "mapped field" in mail merge field options?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Caseybay - 02 Aug 2006 19:43 GMT
I'm setting up the starting document for a Word mail merge. When I insert a
merge field, there's a box to check that says "mapped field". What does that
mean?
Peter Jamieson - 02 Aug 2006 21:16 GMT
Mapped fields were introduced in Word 2002. I believe they were intended to
allow people to develop mailmerge main documents that always used the same
field names, even when the document was connected to different data sources
that used different field names.

For example, suppose you have two lists of addresses in Excel, and they have
the same columns, but with slightly different names, e.g. one uses
"Firstname" and "Lastname"

and the other uses

"Firstname" and "Surname"

When you use the Insert Merge Field dialog, typically the "Database fields"
radio button is selected and you see the field names that are in the Excel
sheet. However, if you click the "Address fields" button, you see a standard
list of field names including "First name" and "Last name". Suppose you now
click "Match fields" When you are connected to the first sheet you can match
"First name" to "Firstname" and "Last name" to "Lastname". If you are
connected to the other sheet, you can instead match "First name" to
"Firstname" and "Last name" to "Surname." Then, when you insert the field,
the \m switch is used to show that it is an "Address" or "mapped" field,
rather than a "Database" field.

When Word connects to a data source, it tries to recognise address field
names and do the matching (or is it mapping?) itself, so using Address
fields is made a bit easier for you. If you are used to using
matching/mapping, it will probably work reasonably well for you. If not,
personally I think sticking to the Database fields is a bit clearer.

Peter Jamieson

> I'm setting up the starting document for a Word mail merge. When I insert
> a
> merge field, there's a box to check that says "mapped field". What does
> that
> mean?

Rate this thread:






 
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.