Send Email via Macro

Question

We have Excel 2010 and Office 365

I have a spreadsheet where everyone uses and when they complete their entries they need to press the macro command button to send the file to an email address.  The email address is in the code.  The problem is the user still has to manually enter the email address before it gets sent.  Any help is appreciated.

Thank you

This is what I tried so far

Application.Dialogs(xlDialogSendMail).Show  ' sends the attachment

SendKeys ("myemailaddress")

or

***** The problem with this method is we get a warning message saying "A program is trying to send an e-mail message on your behalf.  If this is unexpected, click Deny and verify your antivirus software is up-to-date. ....... ***** 

If we can avoid this message that would be great.  We're not allowed to install 3rd party programs to avoid this message....

ActiveWorkbook.SendMail Recipients:="myemailaddress"), Subject:=MySubject

Answer 1

Take a look at the following pages of fellow MVP Ron de Bruin's website:

http://www.rondebruin.nl/win/section1.htm