jmcconnell
New member
- Joined
- Jun 6, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
[FONT="]Hi. I'm a beginner so bare with me.[/FONT]
[FONT="]I've got a worksheet called curtailments and I'm working with the data below:[/FONT]
[FONT="]
[/FONT]
[FONT="]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.[/FONT]
[FONT="]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.[/FONT]
[FONT="]Any help would be much appreciated![/FONT]
[FONT="]I've got a worksheet called curtailments and I'm working with the data below:[/FONT]
[FONT="]
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 |
[FONT="]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.[/FONT]
[FONT="]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.[/FONT]
[FONT="]Any help would be much appreciated![/FONT]