I would like to create a Word document which enables me to choose one of three types. The choice would come in the form of three buttons representing a particular mode of transportation. Planes, cars and motorcycles of which each is the name of a tab sheet in Excel. Within each sheet in Excel there are hundreds of characteristics with each having a unique heading name and a value associated with that name directly under the heading if it is used. For example in Row 1, column A labeled "Drive" and the cell directly below "Front". I only want to identify maybe 75 characteristics or so on any given merge. I was thinking about putting an underscore before the Field Name like "_Drive" and that would indicate I want to include that characteristic in my merge. If no underscore then no mail merge for that field name.
On the Word document I will author the field name locations to put all the field names in their respective locations and after the merge any fields not filled would be deleted from the final document. I believe this will require some VBA programming but I'm not Word VBA smart yet. Any help would be great if this problem is possible.
Tony
Bookmarks