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

 | 2013-02-16 00:00:00 |  |  |  | Engine  - PROGRESS CHART |  |  |  |  |  |  |  |  |  |  |  |  | Costing (£)
 |  |  | Job Specification & Description |  |  | Start | End | Review 1 | Review 2 | Review Due |  | Alert |  |  |  |  | Current Status | Totals & Sub totals | Quote | Date | 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
1 | eng1 | 221133 | Propeller Strike Inspection | Ford Anglia | 112 | 2013-02-01 00:00:00 | 2013-02-14 00:00:00 | 7 | 5 | 2013-02-13 00:00:00 | Y |  |  |  |  |  | Complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | New Cylinders | Ford Escort | 123456 | 2013-02-01 00:00:00 | 2013-03-03 00:00:00 | 21 | 11 | 2013-03-05 00:00:00 | N |  |  |  |  |  | Nowhere near complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | eng3 | 10351 | [NAME] | Vw Passat | 445566 | 2013-02-03 00:00:00 | 2013-03-20 00:00:00 | 28 |  | 2013-03-03 00:00:00 | N |  |  |  |  |  | Nearly Complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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