You would need to ensure that the user completing the form trusts you enough to allow macros to run. This is going to be an ongoing problem so I don't think Word is the best solution for you.

I would be using Acrobat or a Web-based form instead.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia