Hi
I have three fields - Title Forename and Surname.
If Title has data I need to mailmerge Title First Char of Forename and
Surname
If title is empty II need first Char of Forename and Surname
Can some kind person tell me the best or most correct syntax please
Thanks
A
Doug Robbins - Word MVP - 01 Nov 2006 06:36 GMT
There is no way extracting the first letter of the forename using mail merge
fields. The best way to do that would be to put the data source into Excel
and then you can use the Left() function to populate a column with the first
letter. While you are doing that there, you could also combine it with the
Title if there is one using the If() function in Excel.
That part of it can however be done using a field construction in Word as
follows:
{ IF { MERGEFIELD Title } <> "" "{ MERGEFIELD Title } { MERGEFIELD
Initial }" "{ MERGEFIELD Initial }" }
You must use Ctrl+F9 to insert the field delimiters { } and you use Alt+F9
to toggle off their display.

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
> Hi
>
[quoted text clipped - 6 lines]
> Thanks
> A
Graham Mayor - 01 Nov 2006 07:04 GMT
You are going to need a fourth field - Initial - which can easily be derived
from the forename field in (say) Excel - but not with Word fields.
The syntax would then be
{IF {Mergefield Title} <> "" "{Mergefield Title} {Mergefield Initial}"
"{Mergefield Forename}"}

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Hi
>
[quoted text clipped - 6 lines]
> Thanks
> A
macropod - 01 Nov 2006 10:19 GMT
Hi Alex,
You'll need to modify your data source to hold the initials as well as the
names. Then your mailmerge could use an IF test against the title to
determine whether to use the name or initials
Cheers

Signature
macropod
[MVP - Microsoft Word]
> Hi
>
[quoted text clipped - 6 lines]
> Thanks
> A