@Badalchad
Read through the following Access Insights articles.
While they relate to Access, the concept will be the same for VBA in Excel.
home > topics > microsoft access / vba > insights > application automation
I and TwinnyFo has an article here too...
home > topics > microsoft access / vba > insights > sending e-mails via outlook - one developer's approach
So, once you have a general understanding of application automation from these two articles we can build on that information/understanding.
Try writing the VBA for the command button and see if you can get the code to compile and run successfully on your PC. There will be some slight changes in the vba code from what is in the articles, but not much, simple stuff like we'd remove some of the database specific code and insert the Excel references - really very minor.
If you cannot get your code to work, then please post back your code to this thread, Insert as text in-line format with the [CODE/] tool, and we can help you tweak the code to get it to run.