jmcconnell
New Member
- Joined
- Feb 2, 2019
- Messages
- 35
Hi. I'm a beginner so bare with me.
I've got a worksheet called curtailments and I'm working with the data below:
The table contents may not always be in this order and the date and times can vary. Therefore I would like to copy the 'Site name', 'start date' and 'time' if for example the table contains 'Forss' and paste them into the body of an email. I know the code on how to access outlook etc.
I can get it to copy the entire row and I can paste that row into another worksheet (There's plenty of examples online) but I can't copy specific cells and get them into the body of an email.
Any help would be much appreciated!
I've got a worksheet called curtailments and I'm working with the data below:
| Site name | Unit ID | Agent | Entity | (MW) | Start time | Start date | Cease time | Cease Date |
| Batsworthy Cross | ODFM44-01 | TestCo1 | Entity1 | 100 | 10:00 | 05/05/2020 | 16:00 | 05/05/2020 |
| Denzel Downs | ODFM45-01 | TestCo1 | Entity1 | 200 | 11:00 | 05/05/2020 | 15:00 | 05/05/2020 |
| Forss | ODFM42-01 | TestCo1 | Entity1 | 0 | 10:00 | 05/05/2020 | 16:00 | 05/05/2020 |
| Little Raith | ODFM80-01 | TestCo1 | Entity1 | 0 | 11:00 | 05/05/2020 | 15:00 | 05/05/2020 |
The table contents may not always be in this order and the date and times can vary. Therefore I would like to copy the 'Site name', 'start date' and 'time' if for example the table contains 'Forss' and paste them into the body of an email. I know the code on how to access outlook etc.
I can get it to copy the entire row and I can paste that row into another worksheet (There's plenty of examples online) but I can't copy specific cells and get them into the body of an email.
Any help would be much appreciated!
