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 / June 2007

Tip: Looking for answers? Try searching our database.

Word 2003 Mailmerge – Address fi    elds

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mary Ann - 25 Apr 2007 16:28 GMT
I am mailmerging a standard letter to an Excel data source and using the More
Items link in the wizard to insert the fields.  I am keeping the Database
Fields checked and do have the fields from my Excel spreadsheet available.  
What are the fields that are shown when I click the Address Fields button –
are they Outlook fields? - they look very similar.
Doug Robbins - Word MVP - 25 Apr 2007 18:22 GMT
I guess you are referring to the fields that make up the AddressBlock field.
Steer clear of it.  You are better off to just insert the mergefields that
YOU want in the configuration that YOU want.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am mailmerging a standard letter to an Excel data source and using the
>More
[quoted text clipped - 3 lines]
> button -
> are they Outlook fields? - they look very similar.
Mary Ann - 15 Jun 2007 08:25 GMT
Thanks for your reply.  I do use the option to insert my own fields but
wanted to understand what those Database fields were.  Problem solved now.  

> I guess you are referring to the fields that make up the AddressBlock field.
> Steer clear of it.  You are better off to just insert the mergefields that
[quoted text clipped - 7 lines]
> > button -
> > are they Outlook fields? - they look very similar.
Peter Jamieson - 25 Apr 2007 23:41 GMT
They are standardised field names. To use them, you have to "map" them or
"match" them to the real names in the data source, which are the "Database
Fields". Word uses a "\m" in a MERGEFIELD field to indicate that it is using
an "Address Field".

The theory is that...
By using them, you can always use the same names in your mail merge main
documents, no matter what the names are in the data sources you connect to.
So for example, suppose you have one Excel file with columns Title, Surname
and Job, and another one with essentially the same type of data but with
columns called T,S and J, you could use the "Address Fields" Courtesy Title,
Last Name, and Job Title in your Mail merge main documents (e.g. {
MERGEFIELD "Courtesy Title" \m } etc.), and in one case map

Courtesy Title to Title
Last Name to Surname
Job Title to Job

and in the other case map

Courtesy Title to T
Last Name to S
Job Title to J

Word does some of the mapping automatically when you connect to a data
source, because it recognises some variants (e.g. perhaps First Name,
FirstName and First_Name).

I quite like the theory, but in practice,
a. doing the mapping is a pain. For example, I would want to be able to
store a simple set of mappings in a file along with the data source
b. I don't think I've ever encountered anyone actually using this approach,
at least as it seems to have been intended. People who use the ADDRESSBLOCK
and GREETINGLINE fields are likely to /have/ to do the mapping, because
those fields rely on the same underlying notion, but in most cases they are
likely to be using Outlook fields which Word mostly recognises
automatically.

Peter Jamieson

>I am mailmerging a standard letter to an Excel data source and using the
>More
[quoted text clipped - 3 lines]
> button -
> are they Outlook fields? - they look very similar.
Mary Ann - 15 Jun 2007 08:26 GMT
Thanks Peter.  So that is the intended purpose!  I feel more comfortable when
I understand, so thank you.  

> They are standardised field names. To use them, you have to "map" them or
> "match" them to the real names in the data source, which are the "Database
[quoted text clipped - 43 lines]
> > button -
> > are they Outlook fields? - they look very similar.
 
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.