Hello Guys

I'm new at typing VBA codes and i got stuck into a code that I'm not able to find anywhere. I have a code that opens an outlook template :

Sub OpenEmailTemplate()
Dim vOL As Object, vItem As Object

Set vOL = CreateObject("Outlook.Application")
Set vItem = vOL.CreateItemFromTemplate("F:\QA\Template.oft")
vItem.Display
Set vItem = Nothing
Set vOL = Nothing
End Sub

So basically what I want to do is to add the subject based on an Excel sheet named "Email" to cell B3 and I dont know how to do this. I was wondering if you can help me with this.