OutLook Form importing Data from Excel Named range

I am looking to create a form that will have areas in it to import data from
a named range in an excel spreadsheet. The user(Sender) should be able to
open the form and it will diplay the constant text "Yesterday’s Forecast"
and below pull in the data from the Excel named range in table format. and
below that import "Weather Observed Yesterday" and then the user(Sender) wil
be able to add their own text. The table import areas should be able to grow
with the table rows. The columns will be fixed. I use VBA but I have not
created any outlook forms. Any help or templets will be greatly appreciated.

Thanks, Len