I have a worksheet with quite a few values that need to be included in a word document.

At present these values are typed into the Custom Properties Dialog manually and referenced throughout the document with the "insert field" option. This saves me re-typing the value every time it is mentioned, and reduces the chance of a copy error.

Is there a way to make Excel write "Custom Document properties" to a word document. I would like to press a button in excel and have it send all the values to the open word document, so I can switch to word and all the custom fields are set.

Thanks

Stuart