Adding body to email via VBA for an outlook template

Hi All,

Im using a macro that links attaches an active workbook to a specific outlook template. However, because im using the template, any time I try to add body to the template via code, it overwrites the template and the email just goes back to a normal one. Please note that within the body I would like to reference cells, hence it would need to be dynamic.

Is there any way to be able to add text to the email template body? Here is the code im working with:

Please Login or Register  to view this content.

Thanks!

Tee