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

Tip: Looking for answers? Try searching our database.

blank fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alex - 31 Oct 2006 23:30 GMT
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
 
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.