Spreadsheet & email help please

[ex_matelot]

I don't know if this is possible but here's my situation:

I have a 4 column excel spreadsheet log with 40 pages, each page representing a customer. During the course of the night the spreadsheet will be updated with various entries. In the morning a report is sent out to each customer. This is being done manually by copy & pasting the excel info.

Is it possible to code something that will allow a block sending of emails of each excel log within a set time period?
I hope that makes sense.

Cheers.

[ExGrunt]

Hi Matelot,

Well it is possible to lash something together with a macro, but it will all be a bit 'Heath Robinson'. It will be really brittle and lack error checking and fault tolerance. But if you must here is a start:
https://support.microsoft.com/en-us/kb/816644

What you are doing is more of a database task and there are plenty of freeware Content Management Systems which would provide a clean web based front end to do the data entry, user management and fully automate the production and sending of the emails. That is the way I would do it.

EG

[OzBob]

This may be a little help for a solution.
We use Postie, a command-line email program, to automatically issue an email message which is a warning message for high temperature situation in a Scada temperature monitoring application running under Windows. i.e. as soon as a setpoint temperature is reached, an automatic email issues a pre-set message to a number of recipients.
I understand it can also be configured to send an attachment file.
More info on it here Infradig Systems - Postie (http://www.infradig.com/#postie)