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 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 New Slipstick.com Articles 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
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
S Visual indicator of a certain property or to show a macro toggle Outlook VBA and Custom Forms 2
L Modifying VBA script to delay running macro Outlook VBA and Custom Forms 3
S Macro to extract and modify links from emails Outlook VBA and Custom Forms 3
M Replyall macro with template and auto insert receptens Outlook VBA and Custom Forms 1
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 2
S Macro for Loop through outlook unread emails Outlook VBA and Custom Forms 2
Globalforester ItemAdd Macro - multiple emails Outlook VBA and Custom Forms 3
S Macro to extract email addresses of recipients in current drafted email and put into clipboard Outlook VBA and Custom Forms 2
witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
witzker Macro to move @domain.xx of a Spammail to Blacklist in Outlook 2019 Outlook VBA and Custom Forms 7
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
Eike Move mails via macro triggered by the click of a button? Outlook VBA and Custom Forms 0
S Macro or plug-in to see if specific person was included in this email Outlook VBA and Custom Forms 4
U Macro for reminders,tasks,calendar Outlook VBA and Custom Forms 4
V macro runs slower on startup than after Outlook VBA and Custom Forms 3
N Macro to move all recipients to CC while replying Outlook VBA and Custom Forms 0
A VBA macro for 15 second loop in send and received just for 1 specific mailbox Outlook VBA and Custom Forms 1
G VBA Macro Calendar Printing Assistant 4

Similar threads

Top