Reply
 
Thread Tools Display Modes
  #1   Report Post  
J&L
 
Posts: n/a
Default How do I remove or supress blank data in fields in mail merge e.g.

I have a some people with middle names and some that don't. When I merge the
data in Word 2003 it shows an extra space! How do I supress blank data?
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Use an If...then...else field.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"J&L" wrote in message
...
I have a some people with middle names and some that don't. When I merge
the
data in Word 2003 it shows an extra space! How do I supress blank data?



  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

Doug Robbins wrote:
Use an If...then...else field.


Hope this helps,
Doug Robbins - Word MVP


eg
{Mergefield First_Name}{IF {Mergefield Middle_Name} "" " {Mergefield
Middle_Name}"} {Mergefield Last_Name}
Note the space before {Mergefield Middle_Name}
Change the field names to suit your data.

--

Graham Mayor - Word MVP

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





"J&L" wrote in message
...
I have a some people with middle names and some that don't. When I
merge the
data in Word 2003 it shows an extra space! How do I supress blank
data?



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
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Empty Mail Merge Fields Meggan Microsoft Word Help 0 January 13th 05 01:43 AM
can data fields be added to an exisiting mail merge address list missode Microsoft Word Help 1 December 20th 04 12:29 AM
Word mail merge data loss Gibson Mailmerge 1 December 8th 04 02:30 PM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 11:46 PM


All times are GMT +1. The time now is 01:00 PM.

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"