>I have a program that will use Word and bookmarks to "mail merge". My problem is, if nothing is inserted at the bookmark (i.e. field is blank) how can I delete that line in Word so there are no empty lines?
>
>For instance, I have bookmarks for name, address1(street address), address2(i.e. suite #), city, state, and zip. Address2 is empty and the blank space is inserted into the bookmark. If it's empty I don't want any space in there.
>
>Thanks in advance for your help!
with oWord.ActiveDocument
.Bookmarks("Address").Select
if empty(Address)
.Application.Selection.Delete
else
Cetin