Hi all,

I have a userform which collects all the data I need to include on an email. I have written the vba code that creates the email as required: 

Please Login or Register  to view this content.


but now need to use a oft template file and populate the data in this template before sending.

How do you refer to an oft file, and how do you match up the text boxes on the user form with corresponding key words or phrases that are included in the oft file?