AutoExec macro e-mail

[robphillips79]

Hello,

I have a 2013 Access Database that is used for daily reporting. It is scheduled to run through a Windows task. It simply opens, runs an Autoexec macro to output query data into a CSV file on a network share, and then closes. I'd like to have an e-mail sent to me after it runs letting me know if it was successful or not. Is this doable in an AutoExec macro? Any guidance would be appreciated. Thanks.

[pbaldy]

I personally would use VBA, but you should be able to use SendObject in a macro to send an email. It would have to be able to be sent without user intervention.

[robphillips79]

I personally would use VBA, but you should be able to use SendObject in a macro to send an email. It would have to be able to be sent without user intervention.

Thank you for the reply, but I do not see SendObject as an action item within the Macro window. One thing I have thought of is to open a form that uses OnLoad VBA to send an e-mail, but in order to do that I need to provide enough time for the form to stay open and send the e-mail before the close action takes place. Is there a way to create a "pause" so that the e-mail has time to process?

Thanks again.

[pbaldy]

What version? I see it in 2007. I've got other versions on VM's.

[robphillips79]

What version? I see it in 2007. I've got other versions on VM's.

Access 2013. It appears you can only send email on data macros. I've gotten this to work however. Luckily, Access is letting the form load and send the e-mail before the close window action happens. All is good. Thanks for the replies.

[pbaldy]

Glad you got it sorted out.