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.
Thread starter Similar threads Forum Replies Date
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
P How may I customize with an own immage a standard email Using Outlook 6
D In Outlook 2007 on Windows 7 64 bit Customize Current View 'Other Settings' Fonts changes do not hold Using Outlook 2
K Can I customize OL2010 month view calendar to be more legible; skip confusing colors and show more a Using Outlook 1
W Customize accounts (folderlist) in navigation pane Using Outlook 5
J Customize Outlook view to fit Smartphone display via i.e. Citrix Receiver ? Using Outlook 1
M Customize Current View of PST Files Using Outlook 2
P Customize Appointment Form Using Outlook 1
U How to customize exch 2010 smtp bounced msg like 5.7.1 or 5.7.11 Exchange Server Administration 2
S Customize Text on OWA Change Password Form Exchange Server Administration 3
J How to customize the To-Do list to show items from only one specific mailbox? Using Outlook 2
J The filter Button is dimmed in the View - Customize Current View dialog. Using Outlook 2007 on Exchange. Using Outlook 3
C Customize Themes Exchange 2010 SP1 Exchange Server Administration 4
R customize contacts Using Outlook 1
K OWA 2010 - Any way to customize the Calendar Sharing Invitation? Exchange Server Administration 1
A Customize Colours Using Outlook 1
G BCM 2007 Customize Current View not sticking Using Outlook 2
C Customize Current View - Group By & Remove This Column Using Outlook 2
A when i customize new fields in the contact menu, it displays under define fields but does not display when trying to imput a new contact. Using Outlook 1
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
S Macro or plug-in to see if specific person was included in this email Outlook VBA and Custom Forms 2
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 3
R Help Revising VBA macro to delete email over different time span Outlook VBA and Custom Forms 0
Similar threads


















































Top