To create a macro ...

Select Tools + Macro + Macros, where it says Macros in, select the template you want to store the macro in; where it says Macro name, type a name, and click Create.  You will see something like 

Sub MyMacroName()
'
' MyMacroName Macro
' Macro created 03/08/00 by Me'

End Sub

You can safely delete the lines in the middle, and add your own code.