I work a uniformed security job. At my job, we have a number of duties. Among them are responding to alarms and submitting reports on those alarms. I have a pretty good template already, but I’d like to automate it a little further.
When responding to alarms, we call our dispatch office for pertinent information such as times, type of alarm, incident number, and identification number of the dispatcher. Normally we’ll write that information down and transfer it into our report (or in my case input that data into variable cells).
I want to be able to take the information down in my phone, email it to my work email, and then when I get back into the office, open Outlook and Excel, and populate some of my variable cells with the information from the email.
Planned format as shown:
*Line 01* Motion (Type of Alarm)
*Line 02* Proprietary (Class of Alarm)
*Line 03* 57 (Building Number)
*Line 04* 2 (Floor Number)
*Line 05* 257-Z (Specific Area)
*Line 06* 011522 (HHMMSS of Alarm Time)
*Line 07* 011544 (HHMMSS of Dispatch Time)
*Line 08* 011733 (HHMMSS of On-Scene Time)
*Line 09* 012022 (HHMMSS of Clear Time)
*Line 10* 8675309 (Incident Number)
*Line 11* 1234567 (ID Number of Dispatcher)
An email that I have sent looks like this:
EXT email: be mindful of links/attachments.
Motion
Proprietary
57
2
257-Z
011522
011544
011733
012022
8675309
1234567
Here’s a picture of my inputs page in my excel template:
What can be done?
Haven’t tried anything yet, because I tried to google it but all my results were about exporting entire emails into excel, or filling outlook based off an excel template.