Is this this programming correect for emailing?
Posted on 2005-05-10
Set oRS = Nothing
MailText = MailText & "<br><br>This email was sent as a system test .<br>"
MailText = MailText & "Please contact REB for further details, or to be removed from the email list<br>"
MailText = MailText & "</body></html>"
If Not(MailTo = "")Then
Set EmailAlert = CreateObject("Outlook.Application")
Set EmailNameSpace = EmailAlert.GetNameSpace("mapiprofilename")
Set MailIitem = EmailAlert.CreateItem(0)
MailItem.Subject = "PPCMS"
MailItem.HTMLBody = MailText
MailTo = ""
MailText = ""
Is this the correct scripting for using a mapi profile on a sql server? - it seems to run fine but doesnt seem to send any email!!
any help would be greatfully received..