Access 2 Outlook Issue

Kevin Field

Registered User.
Local time
Today, 14:59
Joined
May 26, 2010
Messages
35
Hi all,

I have numerous macros which have the 'sendobject' function. they are sending snapshots of a report to individuals and then also cc'ing the report to another person.

This all works tickedy boo.

However, when you run the macro, it uses Outlook to send them. And you get the message similar to:

"This program is attempting to send an email on your behalf. If you do not recognise this request it could be a virus and should be stopped"

You then get five seconds (on a bar). You have to press YES for each message you send via this method. Bearing in mind some of my macros have 30 people the report, you can see this could take some time.

Is there anyway to remove this? It would make my life a hell of a lot easier.

Thanks!
 

Users who are viewing this thread

Back
Top Bottom