Hi JennEx,

With your code, I take it you're using it in a different document to the one we've discussed previously. Your reference to "a workbook that doesn't exist" suggests you haven't defined (or, perhaps, populated) the StrSrc variable. Errors like this are easily trapped if you make it a rule to prefix all code modules with 'Option Explicit'.

Regarding the alternate 'SubResp' values, that could be done via an InputBox. You'd want some good validation with that, though, or the code will fail with all sorts of dialogs etc that will only confuse the user.

As for using the macro for fields in headers and footers, no, it's not really designed for that. But then, it's a simple matter to paste the 'text' code into the body of a document, convert it, then cut & paste the converted code into the header or footer.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]