S
scott_f_cote
OK. Need some help here.
We have created Word templates that we use VBA Macro to merge (mail
merge) data from a text file (we actually are pulling it out of a
database which creates a dump of the record in a text file).
In the document, there are also variables we want the end user to
choose. So, we have set up dropdowns in the Template.
The problem is, to be able to use the dropdowns, we have to protect the
document. Once we protect the document, we error out on the merge.
Have tried protecting only a section of hte document where we do not
merge any data into but it still errors out.
Any one have any ideas? I am not opposed to creating and adding
dropdowns via the VBA but I am not knowledgable in the VBA (these
docs/this process were inherited from another person).
Thoughts????? HELP
Thank you so much in advance.
Scott
We have created Word templates that we use VBA Macro to merge (mail
merge) data from a text file (we actually are pulling it out of a
database which creates a dump of the record in a text file).
In the document, there are also variables we want the end user to
choose. So, we have set up dropdowns in the Template.
The problem is, to be able to use the dropdowns, we have to protect the
document. Once we protect the document, we error out on the merge.
Have tried protecting only a section of hte document where we do not
merge any data into but it still errors out.
Any one have any ideas? I am not opposed to creating and adding
dropdowns via the VBA but I am not knowledgable in the VBA (these
docs/this process were inherited from another person).
Thoughts????? HELP
Thank you so much in advance.
Scott