Hi
I've written (using others code as a basis) a macro which on clicking a button on the tool bar opens a new e-mail with the reverse date in the subject line, eg 070530 would be todays, (it's just what we do). I can also add for instance the current contract name I'm working on as well. Then I only have to type a couple of extra descriptive words.
However others in the company have seen this, and want to do the same. The problem is they aren't capable of editing macros within VBA and so I want to know if it's possible to use a dialog box, in which they can type their subject, and then have this entered into or called from the macro.
I asked something similar earlier and had no reply. If the answer is no I'd like to know that as well.
I'm currently playing with the idea of storing the words in a spreadsheet (Which they'd be happy editing) and calling this, copying the cell value and pasting this into the subject line. Not sure if this is possible either. However using code I found here it's possible to paste words into the spreadsheet from the macro, so I'd have thought it could work the other way. However hopefully there's a more elegant way.
Hopefully someone will let me know one way or another.
Regards
Jeff T