Hi All,
I have the bellow table on a spreadsheet, courier is a drop down list where any of the below could be chosen, what i want to know is if its possible to make it so when ever i select a certain currier from that list can it send an email involving that row. e.g if i select Gopher on row 3 it will email me with the whole of row three?
Apologies if i haven't made this clear i'm fairly new to VBA code and only just created an account today
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I have the bellow table on a spreadsheet, courier is a drop down list where any of the below could be chosen, what i want to know is if its possible to make it so when ever i select a certain currier from that list can it send an email involving that row. e.g if i select Gopher on row 3 it will email me with the whole of row three?
Apologies if i haven't made this clear i'm fairly new to VBA code and only just created an account today
| Order Number | Customer | Courier | Notes | Tracking refrence |
| 47386 | Climate Control | Bow | ND | OUK1716 |
| 47373 | RJ B | Gopher | 2nd Drop | |
| 47412 | Firstgate Services | Bow | ND Pre 10.30AM | OUK1717 |
| 47421 | Stay Cool | Direct | Fujitsu - NOTT32611 | |
| 47292 | FWP | Gopher | 1st Drop | |
| 47431 | RSY | BOW | ND | OUK1718 |
| 47439 | Melton | Gopher | 3rd drop | |
| 47446 | Cool Tech | Bow | ND Std. |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
