Excel Macro for emailing

I’d like to set up a macro to email my current file to several different email addresses. Two questions: #1 – how do I set that up? #2 – is there a way to prevent the message from MS Outlook that says something like “another program is trying to send an email on your behalf, would you like to continue”, or something like that? Thanks