I have an MS Access database that requires some automation enhancements. These include:
* bulk data import from csv
* data processing
* export to email
These are all routines that I currently manage manually.
I also need certain data to be exported to CSV/label. Currently, I export the CSV from Access, import it into mail merge template (currently InDesign), then apply colour to groups of text (all predictable). I need this to be automated (and accept that it is unlikely to be managed in InDesign).
I am not tied to MS Access and will consider a move to online database.