Auto Emailing Macro needs fix

**kiranpat** · 12-28-2012, 03:07 PM

Hi excel masters,

I am working on a macro that is aimed to send emails to people listed on the spreadsheet however the code I am using seems to be bit annoying.

It gives me a pop up box that asks my permission before it sends an email out. any help in getting this fixed is of great help. (looks like this is due to late binding method)

Also, would like to add a msg box that would tell the user that emailing activity is complete and now the file is safe to close. once the user clicks ok then the file should close automatically.

I have attached the file for reference.

Looking forward for your help...

Regards,
Kiran

**Leith Ross** · 12-28-2012, 09:44 PM

Hello kiranpat,

Those annoying messages are displayed by Windows as part of the security changes for Outlook. Unless you have opened Outlook manually, these messages will appear. There are options to using Outlook. Unless you are sending the simplest of emails, the available programs may not have the programming options you need, or are difficult to setup, or cost you money. You can search for Free E-mail Clients or Outlook Compatabile E-mail Clients. However, I can not recommend one.