LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Automated Email Messages from Excel w/VBA

Hi - the routine below sends an email message on behalf of
outlook from MS Excel. Every time it tries to send an
email a message in outlook pops up saying that another
application is trying to send an email on outlook's
behalf, would i like to allow this?

Does anyone know if there is a way to avoid having outlook
display this message and just send the email? My routine
is displayed below my signature. Thanks!
-Aaron

Sub SendEmails()

'\\DECLARATIONS\\
Dim mlNewMessage As MailItem
Dim myOlApp
Dim strBody As String

'\\-BUILD EMAIL BODY-\\
strBody = "This is the Email Body"

'\\E-MAIL GENERATION BUILD BEGINS HERE\\
Do Until Range("A1").Offset(a, 0) = "STOP"

Set myOlApp = CreateObject
("Outlook.Application") 'Create New Outlook Item
Set mlNewMessage = myOlApp.CreateItem
(olMailItem) 'Create New Mail Item
mlNewMessage.Body = strDear & strBody &
strConfidentiality 'Defines Email Body
mlNewMessage.Subject = "Message
Subject" 'Defines "Subject"
mlNewMessage.To = Range("A1").Offset(a,
1) 'Defines "To"

mlNewMessage.Send
'Sends Email Message

Set myOlApp =
Nothing 'Clears
mlOlApp Variable
Set mlNewMessage =
Nothing 'Clears mlOlApp
Variable
a = a + 1
Loop

End Sub
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export messages to Excel Eric_NY Excel Discussion (Misc queries) 1 May 27th 09 11:59 PM
how do i send an automated email from excel using an if statement Daniel Excel Worksheet Functions 0 August 5th 08 11:07 AM
Excel'03 - non printing help/hint automated messages working Excel Discussion (Misc queries) 5 July 25th 07 02:06 AM
can an automated notification (on xls file changes) email can be anat_ny Excel Discussion (Misc queries) 1 July 10th 07 07:16 PM
Excel messages for Blackberry RPTGuy Excel Discussion (Misc queries) 0 March 23rd 05 05:55 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"