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.
Similar threads
Thread starter Title Forum Replies Date
S Outlook 2021 How to customize colors Outlook 2021 & Office 2021 on PC Using Outlook 0
e_a_g_l_e_p_i Trying to customize the ribbon but can't figure this one out Using Outlook 3
S Outlook 2016 Understand and customize prepended behavior of recurring task Using Outlook 0
S Customize the autocolor font choices for replying/forwarding messages Outlook VBA and Custom Forms 2
Y Outlook Task View - Table Format - Customize Reminder Time to Drop-Down Selection Using Outlook 2
V not able to change name in customize Ribbon Outlook VBA and Custom Forms 1
B Customize contact record phone fields Using Outlook 2
A Customize meeting form. Private notices Outlook VBA and Custom Forms 3
J Customize Attachement Security Warning Using Outlook 1
T Customize Outlook flag Using Outlook 1
H I need a developer to customize an Outlook Contact form Outlook VBA and Custom Forms 0
S How can I Customize Message Header in both Reading Pane and Open Message Design? Using Outlook 1
M Customize Comments / Notes Section time stamp on Contact Records BCM (Business Contact Manager) 0
Diane Poremsky Customize the Outlook Toolbar, Ribbon or QAT Using Outlook 0
Ankit Agrawal Customize themes in outlook 2010 Using Outlook 1
M please customize this code Using Outlook 1
M please customize this code Using Outlook 1
B Customize OWA page to open in a new window when logging in Exchange Server Administration 1
G Customize Outlook Today folder Using Outlook 0
O BCM 2010 - Customize a field with a consecutive number? BCM (Business Contact Manager) 1
M How can I customize the Follow Up Flag message in Quick Steps? Using Outlook 1
C Anyone found a way to customize search? BCM (Business Contact Manager) 5
L How to customize the Advanced Find form Outlook VBA and Custom Forms 1
D Re: How to customize the Advanced Find form Outlook VBA and Custom Forms 1
T Customize button image for separate Outlook forms region Outlook VBA and Custom Forms 2
R How to implement customize toolbar in outlook? Outlook VBA and Custom Forms 1
N Customize current view (in Account List) Business Contact Manager BCM (Business Contact Manager) 1
N How to add fields to customize reports in BCM? BCM (Business Contact Manager) 3
C CreateItemFromTemplate throws OutOfMemoryException Outlook VBA and Custom Forms 0
V Macro to mark email with a Category Outlook VBA and Custom Forms 4
M Outlook 2019 Macro not working Outlook VBA and Custom Forms 0
S Outlook 365 Help me create a Macro to make some received emails into tasks? Outlook VBA and Custom Forms 1
Geldner Send / Receive a particular group via macro or single keypress Using Outlook 1
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 17
V Macro to count flagged messages? Using Outlook 2
sophievldn Looking for a macro that moves completed items from subfolders to other subfolder Outlook VBA and Custom Forms 7
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Macro to block senders domain Outlook VBA and Custom Forms 1
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
witzker Outlook 2019 Macro to answer a mail with attachments Outlook VBA and Custom Forms 2
A Outlook 2016 Macro to Reply, ReplyAll, or Forward(but with composing new email) Outlook VBA and Custom Forms 0
J Macro to Insert a Calendar Outlook VBA and Custom Forms 8
W Macro to Filter Based on Latest Email Outlook VBA and Custom Forms 6
T Macro to move reply and original message to folder Outlook VBA and Custom Forms 6
D Autosort macro for items in a view Outlook VBA and Custom Forms 2
S HTML to Plain Text Macro - Help Outlook VBA and Custom Forms 1
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1

Similar threads

Top