Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SSwan SSwan is offline
external usenet poster
 
Posts: 5
Default Title Forename Surname

Hello,

When doing a mail merge of an address the first line of merge fields are
'Title Forename Surname'. When 'Title' is blank it just prints a space and
then prints the Forename and Surname. Is there a way to avoid a blank space
and shuffle the Forename and Surname along but if the next record has a Title
for it to show it?

With thanks.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Title Forename Surname

Use a conditional field to insert the title and the space
{IF {Mergefield Title} "" "{Mergefield Title} "}{Mergefield Forename}

--

Graham Mayor - Word MVP

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


SSwan wrote:
Hello,

When doing a mail merge of an address the first line of merge fields
are 'Title Forename Surname'. When 'Title' is blank it just prints a
space and then prints the Forename and Surname. Is there a way to
avoid a blank space and shuffle the Forename and Surname along but if
the next record has a Title for it to show it?

With thanks.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SSwan SSwan is offline
external usenet poster
 
Posts: 5
Default Title Forename Surname

Thank you Graham. Why didn't I think to do that!
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I use just the first character of a forename in a merge Steve hayes Mailmerge 3 May 11th 07 04:31 PM
{MERGEFIELD"Title"} is now showing for Title merge field before Debbie Mailmerge 2 February 20th 06 03:18 PM
How can I keep initials and surname together? southerleigh Microsoft Word Help 1 July 19th 05 06:34 PM
How to get contact list when creating envelope address in surname La Durande Microsoft Word Help 1 July 8th 05 03:44 PM
Add a title to Title drop down menu Brian Ellis Mailmerge 2 December 11th 04 09:16 PM


All times are GMT +1. The time now is 01:44 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"