RonAndAccess
New member
- Local time
- Yesterday, 18:12
- Joined
- Dec 31, 2012
- Messages
- 2
The following code works great with Outlook 2007, sending to a Yahoo Mail account without the pesky "Logon Prompt"
Dim OutApp As Object
Dim OutMail As Object
Dim strBody As String
On Error GoTo Err_SendEmail_Click
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
strBody = " text "
Set OutMail = OutApp.CreateItem(0)
OutMail.To = "xxxxx@xxxxxx"
' OutMail.BCC = "xxx@xxxxx"
OutMail.Subject = " subject "
OutMail.Body = strBody
OutMail.Send 'Send | Display
---------------------------------------------------------------------------
One solution to getting rid of the "Logon Prompt" in Outlook 2007
Select Tools > Options > Mail Setup >
Select "Send/Receive" button
Uncheck "Schedule an Automatic Send/Receive" every 30 minutes
Dim OutApp As Object
Dim OutMail As Object
Dim strBody As String
On Error GoTo Err_SendEmail_Click
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
strBody = " text "
Set OutMail = OutApp.CreateItem(0)
OutMail.To = "xxxxx@xxxxxx"
' OutMail.BCC = "xxx@xxxxx"
OutMail.Subject = " subject "
OutMail.Body = strBody
OutMail.Send 'Send | Display
---------------------------------------------------------------------------
One solution to getting rid of the "Logon Prompt" in Outlook 2007
Select Tools > Options > Mail Setup >
Select "Send/Receive" button
Uncheck "Schedule an Automatic Send/Receive" every 30 minutes