Are you comfortable with writing VBA macros in Excel? And do you have Microsoft Outlook installed?
If so, you could write a macro that creates the message via Outlook, then adds the attachment, then either opens the message in Outlook for the user to preview, or just sends it straight away. The code would be fairly simple. I have done this sort of thing myself on several occasions. I can't give you any actual code, because I am not a VBA expert; I use Visual FoxPro, but the basic concept of the code would be the same.
You could then place a command button in your worksheet, and execute the VBA code from the Click of the button. Or, you can assign a keyboard shortcut to the macro. Either way, the user would then have an easy way of sending the email.
The email would normally be sent from whichever account you have set up as the default in Outlook. If you have a special reason for sending it from GMail, then you should set the mail item's SentOnBehalfOfName property to the GMail address you want the message to come from.
The only possible difficulty I can foresee is if the workbook is sending itself, that is, if the workbook that contains the macro is the same workbook that you are attaching to the message. In that case, it should be enough for the macro to save the workbook before sending it, but I'm not completely sure about that.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads