Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Create Sound Alert and Email Alert when Macro is Finish
Search Google for a product called Redemption.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "SteveC" wrote in message ... Tom, thanks. I tried de Bruin's code, but I ran into a small problem: MS Outlook provides the following alert msg: "A program is trying to automatically send email on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose 'No.'" Any clue how to disable this... since I'm trying to notify myself from the public workstation computer, it's not really feasible to keep this caution function enabled... the help button provided no clue... "Tom Ogilvy" wrote: for information on emailing with code (Ron de Bruin's site) http://www.rondebruin.nl/sendmail.htm -- Regards, Tom Ogilvy "SteveC" wrote: Hi, wondering if anyone has code that would play a sound for 30 seconds once a macro is finished running. Better yet, send an email to someone alerting that a macro is finished. I need this alert because a macro I created calls upon some other programs that take eons to finish (not excel's fault), and I use this particular program at a computer open to everyone in our office (not at my desk). I guess you could assume that a 30 second sound-clip could be be saved to the c:\, where macro would access it. Maybe I could add a worksheet with a list of name contacts... starting at cell A1, maybe wtih the possibility of adding a few more contacts... Thanks for thinking about this... SteveC Basically: Sub test() oringal code here sound and/or email alert code here end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does anyone know how to create an alert in Excel/Acces ie email al | Excel Discussion (Misc queries) | |||
How do I create a sound alert in excel spreadsheet | Excel Discussion (Misc queries) | |||
How to Create Sound Alert and Email Alert when Macro is Finished | Excel Programming | |||
Sound alert | Excel Discussion (Misc queries) | |||
How can I make a sound alert using macro in Excel! (But not use speaker) | Excel Programming |