Word 2000 IF-THEN-ELSE delete blank line

[stubnski]

Hi experts

Is there a formula that will say
If address2 ="" then delete this line else address2.

It is for a mail merge. The program that I need to use connects to Word, but it will not use the suppress blank lines when merging option. So I have a blank line in the members address on some records that I need to delete.

Hope this is enough information.

Also can anyone recomend any sites or books for programming in Word.

TIA

Stubnski

 

[mintjulep]

If address2 = "" then there is nothing to delete.

Maybe something like:

if ltrim(address2) = chr(13) then address2 =

 

[macropod]

Hi Stubnski,

You don't need vba for this - see my reply in the Word forum.

Cheers

[MS MVP - Word]