Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Nancie Nancie is offline
external usenet poster
 
Posts: 2
Default REMOVE BLANK LINE IN MAIL MERGE

I am using Office 2007 and can't get see where to tell my mail merge (data is
a .csv file) to remove the blank line if no data exists. Does anyone know?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default REMOVE BLANK LINE IN MAIL MERGE

Although the old mailmerge helper, which contained that options is still
buried in the program, with that option, which may even still work (you can
add the command to the QAT (Quick Access Toolbar) ) the better way is to use
conditional fields eg

{Mergefield Fieldname1}{IF {Mergefield Fieldname2} "" "
{Mergefield Fieldname2}{IF {Mergefield Fieldname3} "" "
{Mergefield Fieldname3}{IF {Mergefield Fieldname4} "" "
{Mergefield Fieldname4}etc

Use CTRL+F9 for the field brackets if entering directly from the keyboard.

--

Graham Mayor - Word MVP

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


Nancie wrote:
I am using Office 2007 and can't get see where to tell my mail merge
(data is a .csv file) to remove the blank line if no data exists.
Does anyone know?



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 do I remove blank lines in mail merge labels in Word 2003 Islandtop Mailmerge 2 December 7th 07 07:24 PM
Mail Merge how do you leave a blank line for items with no value? YK Mailmerge 1 September 28th 06 06:10 PM
Is it possible to retain a blank line in mail merge? Roy Laws Mailmerge 1 October 6th 05 04:38 AM
How do I remove or supress blank data in fields in mail merge e.g. J&L Mailmerge 2 January 14th 05 07:04 AM
How do I keep a blank line from printing in a mail merge? Record. Kellye Mailmerge 1 December 8th 04 01:50 AM


All times are GMT +1. The time now is 08:02 AM.

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

About Us

"It's about Microsoft Word"