I think the original answer by harrymc does what you want. I voted for it and added it to my collection of useful macros.
Here is my modification to the macro, which you may feel is an improvement.
How do I insert the current user's name based on (Log in ID)
explains that the login name is stored in a Windows
environment variable named USERNAME, which can only be retrieved
by a macro ...