0

I have some mail templates I & my colleagues frequently use in Outlook 2010, which need to be sent from a shared mailbox. Every time I send one, I need to first change the 'From' address (like this: From address selection), which takes time and can be overlooked.

Is there a way (macro or otherwise) to save the from address as part of the mail template (.oft), so it does not have to be set every time?

2 Answers 2

1

Took some trial and error, but here's the macro:

Sub templateName()
Dim objMsg As MailItem

Set objMsg = Application.CreateItemFromTemplate("C:\Users\User\AppData\Roaming\Microsoft\Templates\templateName.oft")

    With objMsg
        .SentOnBehalfOfName = "[email protected]"
        .Display
End With

End Sub
1

There is no built-in option in Outlook to save the From field in an template. As per macro, I found a similar discussion in another forum but the macro mentioned there didn't work for me.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .