B
Bret
Im using the SendMail code (shown below) in my VBA program to send Excel
workbooks. The code (provided by this board) works great except for the
fact that Outlook has the dialog box that says "A program is trying to
automatically send an email on your behalf? Do you want to allow this?"
Normally this isn't a problem, however my program is looping thru a
spreadsheet of about 500 names and email addresses so of course this is
cumbersome.
Can this feature be disabled from within Excel or from Outlook?
Sheets(Array("Sheet1", "Sheet2")).Copy
'ActiveWindow.SelectedSheets.Copy
Set wb = ActiveWorkbook
With wb
.SaveAs "C:\Documents and Settings\"
.SendMail "email address here", _
"comment here"
.ChangeFileAccess xlReadOnly
'Kill .FullName
.Close False
End With
much thanks.
workbooks. The code (provided by this board) works great except for the
fact that Outlook has the dialog box that says "A program is trying to
automatically send an email on your behalf? Do you want to allow this?"
Normally this isn't a problem, however my program is looping thru a
spreadsheet of about 500 names and email addresses so of course this is
cumbersome.
Can this feature be disabled from within Excel or from Outlook?
Sheets(Array("Sheet1", "Sheet2")).Copy
'ActiveWindow.SelectedSheets.Copy
Set wb = ActiveWorkbook
With wb
.SaveAs "C:\Documents and Settings\"
.SendMail "email address here", _
"comment here"
.ChangeFileAccess xlReadOnly
'Kill .FullName
.Close False
End With
much thanks.