vba code to delete the empty bookmarks in Word document

Hi all,

I have been automating reports that will be generated in word documents for every company. The baseline is that I have a excel sheet which contain the data inputs and a word template document (template with bookmarks). I have written a macro that generate the reports when the user clicks the button but found that there some reports that generates empty bookmarks since there is no data for the corresponding bookmark. I have uploaded the excel sheets that has the full data and the setup sheets. The setup sheet has the Column Number, Bookmark Name, Description. The data sheet has the data values and the code info sheet has the name of the template doc and the name of the destination folder where the reports will be generated and stored. My requirement is to delete the empty bookmark from the report named "Blackberry". I would like some help on this as I don't know on where to write the macro for deleting the empty bookmarks and its sentences (whether its in excel book or word template doc)?

Can anyone help me on this?

I have tried with the code

Please Login or Register  to view this content.

but i get this error Application defined error. Don't know what is the problem. Really stuck with this.

So there is no one to help me?