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

Tip: Looking for answers? Try searching our database.

How can I use just the first character of a forename in a merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve hayes - 11 May 2007 08:19 GMT
I need to set up a mailing from OUTLOOK contacts.  I want to address the name
as title, first character of forename, then surname i.e. Mr John Smith = Mr J
Smith.  I believe it is somewhere in field cods but cannot find anythig under
HELP.
Please assist
Thanx
Doug Robbins - Word MVP - 11 May 2007 10:01 GMT
There is no way that can be done by fiddling with the field code.  You could
execute the merge to a catalog (or directory in Word XP and later) mail
merge in which you arranged the fields so that they produced the names in
the format of Mr John Smith and then you could use a Wildcard Edit>Replace
to dispense with the unwanted part of the forename.  Then that modified file
could be used as the data source.

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 need to set up a mailing from OUTLOOK contacts.  I want to address the
>name
[quoted text clipped - 5 lines]
> Please assist
> Thanx
Graham Mayor - 11 May 2007 11:06 GMT
For individual records (as opposed to mail merge) you can extract this
information from Outlook by using code similar to the example at
http://www.gmayor.com/Macrobutton.htm

Signature

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

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

> There is no way that can be done by fiddling with the field code. You
> could execute the merge to a catalog (or directory in Word XP and
[quoted text clipped - 12 lines]
>> Please assist
>> Thanx
Peter Jamieson - 11 May 2007 16:31 GMT
Without using VBA and Word's Mailmerge events, there are a some approaches
you can take to this (other than storing the initial separately in Outlook),
but they are all awkward to use. e.g.

1. If you have Access, you can link a table to your Contacts list in
Outlook, then write an Access query that takes the leftmost character of the
first name, then use that as the data source. The problem with that is that
Access only retrieves some of the fields from the Contacts folder and they
may not include the ones you need. You may also find that Unicode characters
do do transfer properly.

(To do this, create a new Access database, then use File|Get External
Data|Link Tables...then in the Files of type... dropdown at the bottom of
the Link dialog box, select Outlook() and follow the dialogs. I leave you to
work out how to do the query and so on).

2. Use 26 IF fields in your Word document as follows:

{ IF { MERGEFIELD First_Name \*Upper } = "A*" "A" ""
}{ IF { MERGEFIELD First_Name \*Upper } = "B*" "B" ""
}
and so on down to Z (assuming you only need worry about the 26 basic Latin
letters

Peter Jamieson
>I need to set up a mailing from OUTLOOK contacts.  I want to address the
>name
[quoted text clipped - 5 lines]
> Please assist
> Thanx
 
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.