View Single Post
 
Old 01-21-2015, 06:18 PM
dsjk9190 dsjk9190 is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Jan 2015
Posts: 4
dsjk9190 is on a distinguished road
Default Delete bookmark and paragraph which is blank

I've got a few related queries, so here it goes.
Firstly, I have a cover letter which includes the address details (see below for example)

Mr/Mrs Contact Name
Business Name
Street Address
Suburb State Postcode

As you can see the second line of the address is the business name (which has it's own bookmark). When the userform is populated there may not be a business name filed into the relevant text book (and then bookmark), so how do I go about creating a code to remove this one line (paragraph)?

Secondly, later on in the document there is a reference made to the business name (with a different bookmark), however similar to the first query I want to replace this bookmark with the contact name if the business name textbook has not been populated in the userform. Does anyone have any thoughts or suggestions?

Thanks in anticipation
Reply With Quote