using access to send emails with attachments

[notDave]

Can anyone show me where to find tutorials or the like on
sending email attachments? Or does anyone have
suggestions for the following situation?

I have a module that opens a report (with a where clause),
and output's that report as an excel file attachment in an
email and sends the email. It sends 22 emails. Outlook
has a security feature that pops up a box warning that an
app is trying to send and email and asks if this is okay.
The "Yes" button is INACTIVE for 5 seconds. Once it
becomes active I can click Yes and the email sends. THe
problem obviously is that I have to sit there and click
Yes each time. Any suggestions or good links for
tutorials? Thanks much...

~notDave

 

[Douglas J. Steele]

See whether there's anything in the Access EMail FAQ Tony Toews has at
http://www.granite.ab.ca/access/email.htm

 

[notDave]

Thanks for the info... apparently this is more complex
than I had planned. My head is swimming from all the
options. I'm wading through it...

~notDave

 

[madhouse]

try this:

http://www.contextmagic.com/express-clickyes/

madhouse