ExpressClick Yes

[mikeymay]

I am using Expressclick Yes program to get round OUtlook asking if it is Ok to send emails that are genereated via a macro.

I tghere a way of turning this faciolity on and off using a macro as I don't want to leave ExpressClick Yes on all the time.


Thanks

 

[Legacy 98055]

I would impliment the auto-click functionality into your macros and then use it at will. Please post your code and I'll edit it with a few simple API functions that will close the dialog in Outlook. Where is your code running from? Excel?

 

[mikeymay]

The macro is running via Excel.

I don't have any specific code that starts up ExpressClick Yes as it is installed on my pc and is set to 'Enabled' all the time.

The code for sending the emails tho' is below

With ActiveWorkbook
    .SaveAs strNotRetnDir & "\20" & strYr & "\" & strPeriod & "\Chqs Not Returned " & Format(dtReportDate, "dd mmm yy")
    If boolNone = True Then
        Else
        .SendMail "joebloggs@.co.uk", "Chqs Not Returned - W/o " & Range("B5")
     End If
    .Close
End With

Not fantastic with VBA, but will hazard a guess that I need to declare the app, switch to 'Enabled' then 'Disabled' via code.

Any help with doing this would be a great help.