Hi, I have written a small macro that pulls data from excel to populate a letter with data (eg name, address, and some selected paragraphs). here is an example of my code:

VB Code:
  1. wordarray = Array(addressline1, addressline2, addressline3, addressline4, postcode, Policynumber, Yourref, ourref, date, salutation, para1, para2, para3, para4, signed, position)
  2.  
  3. wrd.Activedocument.Fields(1).Select
  4.     With wrd.Selection
  5.     .InsertAfter Text:=Addressee
  6.     End With
  7.  
  8.    For wrdroutine = 0 To 15
  9.     wrd.Selection.NextField.Select
  10.     With wrd.Selection
  11.     .InsertAfter Text:=wordarray(wrdroutine)
  12.     End With
  13.  
  14. Next
  15.    
  16.     End

My problem is, sometimes para1 may not be applicable, and the same for the rest of the paragraphs. So I could have a letter that will have para2, para3 & para5. This will leave blank spaces were para1 & para4 are. Is there a way so that if para = "" (in this case para1 & para4) then it will delete that line where that are supposed to be input and the one below to bring the text up so there will not be 3 blank lines between the next paragraph entere don the letter?

I hope this makes sense!

many thanks