Hi All,

I've had an ongoing challenge in trying to send an automatic email from an Access database. After researching various solutions, including some recommended on this board, I found a very easy one. I was able to compile the necessary information into a report and set up a Macro in Access to email it. The report just emails as an attachment. It works beautifully and I don't get that pesky Outlook security warning.

I tested this solution in my fake database and now I'd like to implement it in my real database. I just wanted to ask the experts if there's any reason I shouldn't do this, or any reason you wouldn't recommend this course of action. Thank you for all your help!