I have been punted the task of creating a macro for distribution that will append <Signature:USERNAME> to a word document.

USERNAME = Current logged on user.

I have no clue what variable to use for enumerating the current logged on user in VBA.

I have been playing with various things, but due to my lack of experience with VB I have had no success.

Sub NewMacros()

Selection.TypeText Text:="<Signature:Environment.UserName>"

End Sub


I am a little familiar with WSH, but have never done anything with VBA, so any assistance would be appreciated.