Customize CreateItemFromTemplate Macro

Status
Not open for further replies.
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello there!

I am very new to VBA. I created a simple Macro that pulls up a template in Outlook, but I would like to change the address in the 'From' Field. Below is my code so far:

Sub Proposal()
Set msg = Application.CreateItemFromTemplate("C:\Users\My Name \AppData\Roaming\Microsoft\Templates\proposal.oft")
msg.Display
End Sub

I know that the line I am looking for is:

.SentOnBehalfOfName = "email address"

but I don't understand what I'm doing enough to do anything further. Please advise!

Mike
 
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thanks Diane! That's actually what I did AFTER the msg.display, but it apparently only works if you put it before.

So appreciative of your help :)
 
Status
Not open for further replies.
Top