Spreadsheet & email help please
Thread Starter
Join Date: May 2005
Location: 50'11N 004' 16W
Posts: 282
Likes: 0
Received 0 Likes
on
0 Posts
Spreadsheet & email help please
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.
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.
Join Date: Mar 2003
Location: England
Posts: 286
Likes: 0
Received 0 Likes
on
0 Posts
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
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
Join Date: Feb 2010
Location: New Zealand
Posts: 42
Likes: 0
Received 0 Likes
on
0 Posts
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
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