Populating mail message with information in Excel

[cosiek]

Hi,

I have an Excel file with e-mails (F2: till column is populated) and mail templates (J2: till column is populated).

I am trying to create macro, which will:
1. open Outlook new message,
2. copy mail from F2 in TO: section
3. copy mail template from J2 in mail content
4. add subject with specified content "xxx"

Once I run the macro, I would like to have new mail message for each row.
Macro should go until the column F is populated.

Can you please help me with that?

Regards,
Jakub