I have tried your suggestion and it has been unsuccessful.
I have copy/pasted your code exactly how you have said (I don't need to replace any of this code with my own?) and I have also put <ID> (my merge field in excel AND word) in the subject line but this does not work.
Does it matter...
So when I get to the stage of entering the subject line, if the merge field I wanted to insert was "StudentID" i'd enter <_StudentID_> ?
Thanks in advance.
I can't seem to get this to work.
I currently have an e-mail merge which I am creating through Word.
I have created a new Macro and pasted the code you have provided but I get the following error when running the macro (at what point do I run it? am I doing this correctly?) - "Compile Error...