Emailing Access Report using SendObject

G

Guest

Just installed XP and Office 2003. Trying to get my macros working again in
Access. Macro halting at the SendObject line saying: "A program is trying
to automatically send email on your behalf." Have used the SendKeys to add
the keystrokes for answering the dialog window, but hasn't worked for me.

Have already reset Macro Security for Outlook and Access to "Low".

I'm needing this to work because I use Task Scheduler to automatically run
and send Access reports.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top