Hi i am completing a word doc based on a userform entry's. The problem is i am not sure how change a bookmark depending on entry. I will try to explain.
On occasions i write to company's or private landlords.
So the addresses are like so =
The Manager Mr His Name Mr His Name
Company Name Address Company
Address Address
I have bookedmarked landlord and if the name is ommitted it fills in The Manager by default which is fine and working. If there is no company it leaves a blank line in the letter address and i would like to know how i can remove this line. If anyone can help.
My code so far
On occasions i write to company's or private landlords.
So the addresses are like so =
The Manager Mr His Name Mr His Name
Company Name Address Company
Address Address
I have bookedmarked landlord and if the name is ommitted it fills in The Manager by default which is fine and working. If there is no company it leaves a blank line in the letter address and i would like to know how i can remove this line. If anyone can help.
My code so far
Code:
Landlord = "The Manager" If LSurname.Value <> "" Then
Landlord = ComboBox13.Value & " " & LForename.Value & " " & LSurname.Value
End If
Call Module1.UpdateBookmark(wdDoc, "Landlord", Landlord)