By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,067 Members | 1,818 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,067 IT Pros & Developers. It's quick & easy.

Emailing reports from Access 2003

P: n/a
I have several reports being auto-emailed via macros from Access. With
our company's recent upgrades Outlook now pops up a lovely warning
requiring the user to press the Yes button each and every time to allow
the email to be sent. Currently there are 77 iterations of each report
being sent every day.

Anybody have any idea how to put the focus on this popup and add
sendkeys or something to the macros to tab to the yes button and press
enter? (I'm a self-taught intermediate skill level creator who's just
starting to learn VBA so please be gentle!)

Oct 23 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I have used a free piece of software called ExpressClickYes. You can
get that from here:
http://www.contextmagic.com/express-clickyes/

Gabryyl wrote:
I have several reports being auto-emailed via macros from Access. With
our company's recent upgrades Outlook now pops up a lovely warning
requiring the user to press the Yes button each and every time to allow
the email to be sent. Currently there are 77 iterations of each report
being sent every day.

Anybody have any idea how to put the focus on this popup and add
sendkeys or something to the macros to tab to the yes button and press
enter? (I'm a self-taught intermediate skill level creator who's just
starting to learn VBA so please be gentle!)
Oct 23 '06 #2

P: n/a
You should try Redemption.SafeMailItem object
(http://www.dimastr.com/redemption/).

Oct 24 '06 #3

P: n/a
YOU ARE A CERTIFIED GENIUS AND I LOVE YOU!!!!!

This works like a charm - Thanks!

Jeff L wrote:
I have used a free piece of software called ExpressClickYes. You can
get that from here:
http://www.contextmagic.com/express-clickyes/

Gabryyl wrote:
I have several reports being auto-emailed via macros from Access. With
our company's recent upgrades Outlook now pops up a lovely warning
requiring the user to press the Yes button each and every time to allow
the email to be sent. Currently there are 77 iterations of each report
being sent every day.

Anybody have any idea how to put the focus on this popup and add
sendkeys or something to the macros to tab to the yes button and press
enter? (I'm a self-taught intermediate skill level creator who's just
starting to learn VBA so please be gentle!)
Oct 25 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.