I have a spreadsheet named Alarm.xlsx. It has a DB connection to our support system and monitors for certain conditions which updates every 3 minutes. When these conditions are met on a support ticket, it displays that record(s) until someone changes that support ticket in the system.
I have the spreadsheet running at all times, however, you have to physically watch it in order to react if a record shows. I would like for the spreadsheet to send an email (using Outlook and Excel 2012) to two email addresses and reference columns A-L and O & P in the body for each record.
Would anyone please be able to assist me with this?
Best regards,
Chris
Bookmarks