You can use it to send emails via outlook. If you put the following code into VBA in an Excel Spreadsheet, and run it, it will begin an email. The .Display causes the email to pop up so you can send it manually. If you replace it with .send it will send it.
If you want me to email you an example spreadsheet let me know, or if you can send me your example I can tailor it to do this.