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 / September 2004

Tip: Looking for answers? Try searching our database.

mail merge from word with outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
grace - 05 Sep 2004 07:11 GMT
I see many are having this problem, including me. It
appears as if there's a glitch in Outlook, which is
confusing "job title" with "title". It looks like Outlook's
"Job Title" field is merging into word as the "Title" field
with the following results in the greeting line, for
example: Dear Chairman of the Ways and Means Committee
Jones:, rather than Dear Mr. Jones:. Moreover, I don't see
a Title field and don't see a way to create one. The links
mentioned don't appear to address this. Thanks for your help.

grace
Graham Mayor - 05 Sep 2004 09:34 GMT
Start your merge from Outlook -
http://www.gmayor.com/mailmerge_from_outlook.htm which provides access to
*all* the fields.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I see many are having this problem, including me. It
> appears as if there's a glitch in Outlook, which is
[quoted text clipped - 7 lines]
>
> grace
Grace Walker - 06 Sep 2004 18:11 GMT
Thanks, Graham, this is good information. I don't think it's quite
what I'm looking for now but I hadn't tried to initiate from Outlook
because I didn't know that a preprepared merge source document could
be used and the merge letter formats available were totally
unacceptable to my needs. Appreciate your help. My next problem is
portability. I worked out the kinks in the Word document and it works
fine now. What do I need to do to make it work on another machine with
its Outlook contacts? Any help appreciated. Thanks.

> Start your merge from Outlook -
> http://www.gmayor.com/mailmerge_from_outlook.htm which provides access to
[quoted text clipped - 11 lines]
> >
> > grace
Peter Jamieson - 05 Sep 2004 10:21 GMT
This is a really confusing area. There are at least three ways to get data
from Outlook and what happens depends on which version of Word you are using
as well.

If you are using Word 2000 or earlier, typically you will connect to the
data using the Mail Merge Helper. In this case, the Job Title is called
Title, and the other title is called Courtesy Title or Courtesy_Title. This
may vary depending precisely where the address are and how you are getting
them.

If you are using Word 2002 or later, the obvious way to get the data is to
use the Mailmerge Wizard and selecting a Contacts list. However, in this
case you will typically only see a courtesy title, called Title.

To get both titles and see the largest number of fields, the simplest
approach is often to initiate the merge from Outlook. This is possible in
Outlook 2000 and later. Select a contact list, use Outlook Tools|Mail Merge,
and take it from there. The courtesy title should be called Title and the
Job title "Job Title" or "Job_Title". If you are using the fields in the
ADDRESSBLOCK field you may need to "map" the field names correctly.

In Word 2002/2003 it is possible to connect using the old Mail Merge Helper
method, but let's not go into that.

A further source of possible confusion in Word 2002/2003 is the "field
mapping" facility. In essence, Word has a fixed list of "address" field
names. When it opens a data source, it tries to "map" the field names it
finds - which are called the "database" field names onto the address field
names. If you insert individual fields (MERGEFIELD fields) into your mail
merge main document

{ MERGEFIELD "xyz"  } means "use the Database field called 'xyz'"
{ MERGEFIELD "xyz" \m } means "use the Address field called 'xyz'"

By default Word typically maps the Database Title field to the Address
"Courtesy title" field and the Database Job Title field (where it exists) to
the Address "Title" field. This presumably reflects the historical fact that
someone changed the standard names for these things, and Word probably does
the right thing given that there are different lists of names, but it can be
really confusing.

Signature

Peter Jamieson

> I see many are having this problem, including me. It
> appears as if there's a glitch in Outlook, which is
[quoted text clipped - 7 lines]
>
> grace
Grace Walker - 06 Sep 2004 17:57 GMT
Thanks, Peter, for the detailed explanation. What I ended up doing is
deleting the ADDRESSBLOCK grouping and the GREETING grouping and
putting in individual fields because I didn't know how to remap them,
and it worked. What I'm trying to do is create a Word document that
pulls in addressee information from Outlook. It seems to work OK. I
also inserted some autotextlists, which also is working. My problem
now is how to make it portable to transfer to work. Any ideas?

> This is a really confusing area. There are at least three ways to get data
> from Outlook and what happens depends on which version of Word you are using
[quoted text clipped - 48 lines]
> >
> > grace
Peter Jamieson - 13 Sep 2004 08:23 GMT
There are many general barriers to porting mailmerge applications - it's
difficult to cover them all (even if I could remember them :-) ). In this
particular case the main issue is likely to be that the user will have to
re-initiate the merge (how it was initiated in the first place). They are
very likely to lose any sort/filter defined in Word as they do so.

If you initiate from Outlook, what you need to do is put the document in an
easily accessed folder on the user's machine and get them to select the
correct options in Outlook's Tools|Mail Merge dialog box, which lets the
user select an existing document or template. Outlook then exports the data
to a temporary file and automates Word to get it to set up that file as a
data source. It is probably best to encourage the user not to keep multiple
versions of the mail merge main document open as there are likely to be
problems with temp file creationand naming.

If you are encountering a specific difficulty, let us know.

Signature

Peter Jamieson

> Thanks, Peter, for the detailed explanation. What I ended up doing is
> deleting the ADDRESSBLOCK grouping and the GREETING grouping and
[quoted text clipped - 56 lines]
> > >
> > > grace

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.