How do you send energy meter values monthly?
I know how to send it via email, but the problem is that it not an attachment, but insida mail body and managing the data is not comfortable. Also making the email is not very user friendly if you have to send 200 values in one mail.
It would be good to be able to send the values from database or in excel version.
I do it also like that but first it is not comfortable to set it up since you have to add all values manually to email and if something changes for example you change the meter then it is time consuming to replace it.
Another issue is that I am not able to change point to comma and thousands are separated with commas and then I am not able to copy/paste the values.
I use mailparser.io(paid service) to export the meter values to google drives excel. So every site has its own excel that gets updated automatically. But native excel export would be best.
In my situation i have 20 floor with 11 aparment, so i create an email template for that, the is easy to copy/paste in excel
https://docs.google.com/document/d/1gwNZdTFG87Dv2ysPsOlXxGU-eCf4zNcvnQ44dgfzL9U/edit?usp=sharing