Suggestion: add ability to send alerts to email/text
- jamesedwards
- Posts: 2234
- Joined: Wed Nov 21, 2018 6:16 pm
As someone who has automation running 24/7 I would find it extremely useful to add ability to email (or even text-to-mobile) alert messages in the 'Alert' rule type parameters.
- jamesedwards
- Posts: 2234
- Joined: Wed Nov 21, 2018 6:16 pm
Yes, any sort of mobile app integration would be preferred. I'm assuming an automated email or text would be a more realistic first step though.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
You could do it via Excel VBA? (code courtesy of chatGPT) It's dead easy to overload yourself with a thousand emails a second though so be carefuljamesedwards wrote: ↑Fri Mar 31, 2023 4:43 pmAs someone who has automation running 24/7 I would find it extremely useful to add ability to email (or even text-to-mobile) alert messages in the 'Alert' rule type parameters.
Code: Select all
Sub SendEmail()
Dim OutlookApp As Object
Set OutlookApp = CreateObject("Outlook.Application")
Dim OutlookMail As Object
Set OutlookMail = OutlookApp.CreateItem(0)
With OutlookMail
.To = "[email protected]"
.Subject = "Subject Line"
.Body = "Email Body"
.Send
End With
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub
Last edited by ShaunWhite on Fri Mar 31, 2023 5:11 pm, edited 1 time in total.
I've toyed with the idea of using Auto-It\AutoHotkey to detect the BA alert window, grab the text and send it in a mail before. Not gotten around to it though as I just tend to use my mobile to VNC to my desktopShaunWhite wrote: ↑Fri Mar 31, 2023 5:07 pmYou could do it via Excel VBA? (code courtesy of chatGPT) It's dead easy to flame yourself though so be carefuljamesedwards wrote: ↑Fri Mar 31, 2023 4:43 pmAs someone who has automation running 24/7 I would find it extremely useful to add ability to email (or even text-to-mobile) alert messages in the 'Alert' rule type parameters.Code: Select all
Sub SendEmail() Dim OutlookApp As Object Set OutlookApp = CreateObject("Outlook.Application") Dim OutlookMail As Object Set OutlookMail = OutlookApp.CreateItem(0) With OutlookMail .To = "[email protected]" .Subject = "Subject Line" .Body = "Email Body" .Send End With Set OutlookMail = Nothing Set OutlookApp = Nothing End Sub
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
You can send WhatsApp messages from vba as well.
I remember 'back in the day' getting Guardian and Excel to place various amounts at various out of the money prices to create a crude protocol for passing information to each other. I guess you could do that with SVs now somehow but I don't know what the latest BA version can do in much detail (as Dallas found out today ) I've asolutely no recollection now of how I did it or why really, these things are often more effort than their worth or just massive scope creep from just needing a box that flashes.
I remember 'back in the day' getting Guardian and Excel to place various amounts at various out of the money prices to create a crude protocol for passing information to each other. I guess you could do that with SVs now somehow but I don't know what the latest BA version can do in much detail (as Dallas found out today ) I've asolutely no recollection now of how I did it or why really, these things are often more effort than their worth or just massive scope creep from just needing a box that flashes.