Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I delete all blank lines from a plain text file? | Page Layout | |||
blank lines in XP mail merge | Mailmerge | |||
Where did "print blank lines" option go in Office 2003??? | Mailmerge | |||
Change Line Count to not count blank lines | Microsoft Word Help | |||
suppressing blank address lines in mail merge | Mailmerge |