VBA code required to draft emails in outlook taking excel inputs.

Dear all,

I need a VBA code to draft the outlook mails to each unique ID's listed in Column F:F.

Example for one mail and its contents (refer attachment):
1) Mail to be drafted for user "[email protected]" with some default subject line.
2) Mail must carry Columns "A:A, B:B, C:C" data for this user only (From row 1 to 6 for user 'abc') .
Eg: Number1 Description Number2
15756599 INSULATOR ABC 0000
22799842 VEH ABC 0001
22972933 CAP ABC 0002
23164924 NEG ABC 0003
15756599 INSULATOR DEF 0000

As Presently column "F:F" carries 4 unique users, i need 4 similar mails to be generated (drafted) along with their data from this excel sheet.

I have VBA code to generate mail in outlook, but i never keyed in mail ID's and content data from excel.

Number of user is not restricted to 4..Please generalise it to 'n' number of users.

Please help me.

Really awesome.... I am dreaming when I could write VBA to this extent...

Any tips..?

Many Thanks...