I'm currently using a sheet change event to trigger a macro to that uses a word doc as an email body sent via outlook, this works flawlessly. I understand that it is possible to have only one sheet change event per sheet. Therefore I'm limited to a single doc selection.
Is it possible to achieve the same outcome but to have a macro select and use a different word doc depending on the selection of a drop down list ?
Any help you can provide would be great, thanks.
Bookmarks