automate to run multiple email macros

[Guest]

Due to privacy considerations I have created a sendObject macro for each of
the recipients reports separately. There are 100 reports. Is their a simple
shortcut I can add so I do not have to run and click 'yes' to each email
macro individually?

 

[Steve Schapel]

LucB,

I don't know what the message you are getting, but I suspect it has
nothing to do with Access or with your database. It is probably to do
with your email program. If you are using Outlook, it is probably a
security thing. Some people have had success with this third-party
utility...
http://www.contextmagic.com/express-clickyes/

 

[Guest]

Thanks Steve, that makes sense.

regards

LucB