Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting an alert when using the below code to send mail from Excel.
How do I prevent this alert? Thanks for your help... The alert reads: A program is trying to automatically send e-mail on your behalf. Do you want to Allow this. If this is unexpected, it may be a virus and you should choose "No". Sub SendMyMail() Dim subj As String Application.DisplayAlerts = False If MsgBox("Ready to send?", vbYesNo + vbQuestion) = vbYes Then subj = Sheets(2).Cells(7, 3) & " Quote " subj = subj & InputBox("Add to your Subject Line", "email Subject") subj = WorksheetFunction.Proper(subj) 'Emails the activeworkbook' ActiveWorkbook.SendMail ", _ Subject:=subj, ReturnReceipt:=True End If Application.DisplayAlerts = True End Sub -- sb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 giving annoying "Send/Don't Send" error when closing | Excel Discussion (Misc queries) | |||
Excel hangs after using "Send to mail recipient (as attachment) " | Excel Discussion (Misc queries) | |||
Using 2007 Office EXCEL or WORD "SEND" Results in General Mail Fai | Excel Discussion (Misc queries) | |||
Signature missing when "send to" "mail recipient" | Excel Discussion (Misc queries) | |||
How to hide "Send To Mail Recipient" data? | Excel Discussion (Misc queries) |