how to include rows of data from excel in a email automatically

[s_horne]

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

[TABLE="width: 969"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Order Number [/TD]
[TD]Customer [/TD]
[TD]Courier [/TD]
[TD]Notes[/TD]
[TD]Tracking refrence [/TD]
[/TR]
[TR]
[TD]47386[/TD]
[TD]Climate Control[/TD]
[TD]Bow[/TD]
[TD]ND[/TD]
[TD]OUK1716[/TD]
[/TR]
[TR]
[TD]47373[/TD]
[TD]RJ B[/TD]
[TD]Gopher [/TD]
[TD]2nd Drop[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]47412[/TD]
[TD]Firstgate Services[/TD]
[TD]Bow[/TD]
[TD]ND Pre 10.30AM[/TD]
[TD]OUK1717[/TD]
[/TR]
[TR]
[TD]47421[/TD]
[TD]Stay Cool[/TD]
[TD]Direct[/TD]
[TD]Fujitsu - NOTT32611[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]47292[/TD]
[TD]FWP[/TD]
[TD]Gopher [/TD]
[TD]1st Drop[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]47431[/TD]
[TD]RSY[/TD]
[TD]BOW[/TD]
[TD]ND[/TD]
[TD]OUK1718[/TD]
[/TR]
[TR]
[TD]47439[/TD]
[TD]Melton[/TD]
[TD]Gopher [/TD]
[TD]3rd drop[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]47446[/TD]
[TD]Cool Tech[/TD]
[TD]Bow[/TD]
[TD]ND Std. [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]