Hi Tony,
Have you tried recording the steps using the Macro recorder to get started? I don't think there are a lot of folks responding to this forum who are VBA coders. You might try posting to the MS forum for customization:
http://social.technet.microsoft.com/...ct2010custprog