Assign VBA code to shortcut menu 1

[MoiraT]

Hi
Can anyone tell me how to assign VBA code to a shortcut menu item please? I have a macro which sends a report by email when the user clicks "Send report" on their shortcut menu, but I want to change this to VBA code so that I can add more functionality, but how do I assign this code to the "Send report" shortcut menu? I'm sure it is something simple, but I just can't see it! Is it right that I can make the VBA code a procedure within the report?
Thanks for your help.

 

[MoiraT]

I've sorted this by creating a macro that uses the RunCode action that runs the Function I want to use - obvious really. Hope someone else can use this info.