<div>
Excellent. Thanks for that.<br />
<br />
Toco
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have an Outlook template file (.oft) which I want to open within an Excel VBA procedure and automatically modify some of the text, depending on a value in my spreadsheet. <br />
How do I do this ?<br />
<br />
Regards<br />
Toco
</div>
</div>


Hi All,

I have an Outlook template file (.oft) which I want to open within an Excel VBA procedure and automatically modify some of the text, depending on a value in my spreadsheet. 
How do I do this ?

Regards
Toco

How do I open and edit an Outlook template file within VBA ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.