I have "Send on Behalf of" privileges, but when I created a template it reverts back to my default email address instead of the one needed for this message. I need to add this to my macro. the macro is a super simple one to just open the template. the macro works fine except I can't get this one thing.

Sub ADEQrtlyRpt()
'Open ADE Report Email.
Dim MyItem As Outlook.MailItem
Set MyItem = Application.CreateItemFromTemplate("C:\Users\klineberry\AppData\Roaming\Microsoft\Templates\ADE Quarterly Reports.oft")
MyItem.Display

End Sub