Folks

Each time I try to send a mail from my Access 2000 database to a recipient via Outlook 2002 a prompt is displayed basically asking for the users permission to allow a program to use the mailbox in this manner. In fact two boxes appear; 1 with how long do you want to grant access, and another for each mail.

With the various issues around concerning people taking over access to your mailbox and sending mail I can understand this is a good security feature. However, how do I supress the prompt being as I'm the authorised user of my own machine; i.e. I have administerative rights to the PC?

Presumably I need to create a new Mail Item for each mail I send?

Here's my code snippet:

    Set objMailItem = olkApp.CreateItem(olMailItem)

    With objMailItem

        '.To = sRecipient
        .To = "803032307" 'for testing purposes send to myself
        .Importance = olImportanceHigh
        .SentOnBehalfOfName = sMailBoxName
        .Recipients.ResolveAll
        .Subject = sSubject
        .Body = sMsgBody
        .ReadReceiptRequested = True
        .DeleteAfterSubmit = True
        .Send

    End With

    Set objMailItem = Nothing

Which is in a loop so for each record in the database it sends out a mail.

Hope you can help...


Regards

Russ (Programing on L plates..!)

__________________
Regards

Russ (Programing on L plates..!)