Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jan
 
Posts: n/a
Default Supress blank lines

The data source is a .csv file we receive for a merge form letter. It
contains $0.00 in any amount field when no $$$ exist. The data from up to 10
columns are placed in rows within a text box. (See below). I need to supress
all lines when $0.00 exists. For example: PAID1 = $50, PAID2 = $25, PAID3 =
$0.00, PAID4 = $0.00, PAID5 = $0.00, SP_PAID1 = $100, SP_PAID2 = $0.00,
SP_PAID3 = $0.00 - we can only show three rows (PAID1, PAID2, SP_PAID1) with
SPPAID1 directly underneath PAID2. I have tried if...then statements,
switches, and a variety of options with no success in removing rows with
$0.00. Any help would be appreciated. Thank you.

{MERGEFIELD "PAID1"}
{MERGEFIELD "PAID2"}
{MERGEFIELD "PAID3"}
{MERGEFIELD "PAID4"}
{MERGEFIELD "PAID5"}
{MERGEFIELD "SP_PAID1"}
{MERGEFIELD "SP_PAID2"}
{MERGEFIELD "SP_PAID3"}



 
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 delete all blank lines from a plain text file? CX Page Layout 7 October 21st 05 10:50 AM
blank lines in XP mail merge mwest Mailmerge 1 August 19th 05 06:08 PM
Where did "print blank lines" option go in Office 2003??? Emily @ Siemons Mailmerge 1 April 26th 05 06:35 PM
Change Line Count to not count blank lines Carol Microsoft Word Help 4 November 27th 04 01:46 PM
suppressing blank address lines in mail merge Geoff Holt Mailmerge 1 November 26th 04 07:16 PM


All times are GMT +1. The time now is 04:51 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"