Yes you can use a template
however if you use the lineSet msg = OA.CreateItemFromTemplate("D:\Path\templatename.oft")
any text in the template will be overwritten by that content.msg.body = sh.Range("D" & i).Value
If you want to edit the body of the message to include your Excel data you need a different approach - see the code I posted at http://www.vbaexpress.com/forum/show...cro-from-excel