Hi All - we have an email that contains a csv extract of maintenance jobs logged by our tenants on a daily basis, can you give me any advice on how I would:
- Get the data out of the csv file
- then place it into the body of an email
- to then be emailed to our Customer service team
Sometimes these csv files may not contain any data, as no jobs have been logged on our housing system, but the Customer Services Team need to see at a glance if any have, hence the requirement to have the data in the body of the email, also in a table format and possibly if there are no jobs logged, perhaps a message to say that.
The data currently gets emailed from an SQL reporting services subscription that queries the housing system.
Thank you in advance for any thoughts/advice.
