Spreadsheet: 214688d1361051032-re-how-to-auto-send-email-from-multiple-sheets-it-works-on-one-not-on-multiple-production-chart-sample2
Sheet: Propeller

 | 2013-02-16 00:00:00 |  |  |  | Propeller - Progress Chart |  |  |  |  |  |  |  |  |  |  |  |  | Costing (£)
 |  |  | Job Specification & Description |  |  | Start | End | Review 1 | Review 2 | Review Due |  | Alert | PARTS |  |  |  |  |  |  |  | Estimated | Quoted/TBC | Accepted | Date | Payment 1 | Date | Outstanding | Current Invoice Status
Pty | Customer | W.O.No. | Job Type | Unit Desc | Serial No. | Date | Date | in Days | in Days | Yes/No |  | Sent | Parts Description/Part Numbers |  |  |  | Date Ordered | Date Due | Review
1 | prop1 | 10351 | prop re-balance | Sensenich | 445566 | 2013-02-03 00:00:00 | 2013-02-19 00:00:00 | 6 | 7 | 2013-02-16 00:00:00 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [EMAIL] | Bye for now,  [NAME]
2 | [NAME] | 10350 | Repacement prop | [NAME] | 123456 | 2013-02-01 00:00:00 | 2013-03-03 00:00:00 | 6 | 28 | 2013-03-07 00:00:00 | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
3 | prop3 | 221133 | propeller overhaul | Hartzell | 112 | 2013-02-01 00:00:00 | 2013-02-14 00:00:00 | 7 | 5 | 2013-02-13 00:00:00 | Y | 2013-02-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an automated message from outer space | This job shown below with details of the customer and work order needs to be reviewed. |  | Start Date | End Date | [NAME] ([EMAIL]); [EMAIL]; [EMAIL] | Bye for now,  [NAME]
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bye for now,  [NAME]
14
15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Back over to the left again
 |  |  | password =123