Linking to Outlook 2010 from Excel

[Stubby]

I currently have a spreadsheet that collates data. Depending on certain criteria within the spreadsheet I want excel to launch an email using a template stored in Outlook and populate the email with data from the spreadsheet. Part of the data however needs to be placed in a table embeded into the template.

I have seen from other posts how to launch the template and populate the body of the email but I have hit a brick wall with how to populate the table!

Can anyone help!!

I am using the microsoft Office 2010 suite