Here’s what I’d like to do. Write a script/program/some-code/whateverthekidsarecallingitthesedays that:
- Creates a spreadsheet in Excel titled hereinafter ASMNT. It is okay if this overwrites an already existing ASMNT Excel file.
2 Finds every message in my outlook inbox with “assessment results” in the title (let’s say going back to a date I would specify on running the thing).
- For each found email:
3a. Opens any spreadsheet attached to said email
3b. Finds the rows in that spreadsheet attached to that email which contain my name
3c. Copies those rows all into new rows in ASMNT
3d. Closes that spreadsheet attached to that email
3e. Archives that email
I’ve successfully learned bits and pieces of languages before for specific purposes (for example, learned the basics of object oriented programming in Python to take care of a personal project involving string manipulation). So to a certain level of complexity, I can totally learn to do things.
But do the tools exist for creating a script like the one I just described above, where said tools are easily accessible to someone who doesn’t do coding every day?
Or would such a thing be a pipe dream?
(I shouldn’t really be trying to figure out how to do this–I only get into the situation where I’d like to use such a script when I’ve been a Very Naughty Boy and am far behind on a certain aspect of my workload…)