Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code......
Private Sub CommandButton1_Click() Dim myOutlook As Object Dim myMailItem As Object Set myOutlook = CreateObject("Outlook.Application") Set myMailItem = myOutlook.createitem(0) myMailItem.Recipients.Add " myMailItem.Subject = "ProjectStockEstimate-Suggestions and Problems" myMailItem.body = TextBox1 myMailItem.send Set myOutlook = Nothing End Sub Now I have tried to insert this to let not go through the security warnings in outlook with no luck.... ..Display Application.Wait (Now + TimeValue("0:00:02")) Application.SendKeys "%S" Can someone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
How can I automate an e-mail to be send in macro? | Excel Discussion (Misc queries) | |||
Send Mail - Code to test whether Lotus Notes / Outlook is used | Excel Programming | |||
Automate Send To/Mail Recipient | Excel Programming | |||
Annoying "virus" alert when using code to send mail | Excel Programming |