Our company has moved to Gmail and I need to be able to send email from Excel 2010. I have seen a method using CDO but storing users ID and password is not allowed besides they are updated frequently.
I would like it to work similar to the way Excel uses Outlook IE it generates the email with the recipients, subject and attachment and leaves it to the user to send. Would be nice if there was a way to log if the email was actually sent or cancelled.