Ask user to input email template through VBA

Status
Not open for further replies.
S

Shrinivas

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010
Hi All,

This is my first thread in the forum!!!

I am trying to create a VBA macro where I want a user to open an email template saved in his computer. below is what I tried but it is not working. Any help is greatly appreciated. Thanks,

Sub MorningOutlookTemplate()

Dim myolapp As Object
Dim morn_template As String
Set myolapp = CreateObject("Outlook.Application")
myolapp.Session.Logon

morn_template = Application.GetOpenFilename(Title:="Please select report file")
If (morn_template <> False) Then GoTo fine
MsgBox ("Exiting Tool Run!!!!!")
fine:
Range("H11") = morn_template
Set openMsg = Application.CreateItemFromTemplate(morn_template)
openMsg.Display
End Sub
 
Status
Not open for further replies.
< Random problem in VBA macro | Email Macro to add Date and Classification >
Similar threads
Thread starter Title Forum Replies Date
U Disable "Always ask before opening" Dialog Using Outlook 3
C Reports always ask 'Would you like to save your changes?' BCM (Business Contact Manager) 1
D VBA Script (Ask to where to save send mail) Outlook VBA and Custom Forms 1
K Ask about a simple script about save a incoming mail as file on local PC Outlook VBA and Custom Forms 3
S Trying to have a prompt to ask for text to be added to subject before sending. Using Outlook 3
C Ask to Ribbons Outlook VBA and Custom Forms 2
L Meeting invitation not sent to a user Exchange Server Administration 2
D Lifelong Windows user - new to Mac - Help!!! Using Outlook 3
Witzker Outlook 2019 Macro GoTo user defined search folder Outlook VBA and Custom Forms 6
W OL giving basic auth when logged in to Win as specific user Using Outlook 0
Witzker Outlook 2019 How to get a Photo in a User Defined Contact form Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Edit contact from email does not open the user defined contactform Using Outlook 3
Witzker Set Cursor & Focus from any field to the body of a user Contact form in OL 2019 Outlook VBA and Custom Forms 1
Witzker Place cursor at opening, a user defined OL contact form Outlook VBA and Custom Forms 2
ill13 Prepend the user's computer name to the subject. Outlook VBA and Custom Forms 1
J How to create a drop down user defined field that will appear on an inbox view Outlook VBA and Custom Forms 8
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
icacream Outlook 2016 “Enter your user name and password for the following server.” Using Outlook 5
N Item cannot be saved because it was modified by another user or window, and, Item could not be moved... Using Outlook 0
A How to stop user form from disapearing once mail window is closed? Outlook VBA and Custom Forms 0
H Information from user defined field into Excel Outlook VBA and Custom Forms 7
D Outlook 2010 Outlook in Windows 10 keeps asking for user name and password repeatedly Using Outlook 14
E Asking user to select multiple options in a list in an email Outlook VBA and Custom Forms 0
icacream Enter your user name and password for the following server. Using Outlook 4
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
S User Defined Fields adding new value (2) Using Outlook 0
R Creating a user defined function Outlook VBA and Custom Forms 3
M Compile error: User-defined type not defined Outlook VBA and Custom Forms 0
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
G <mailto:user@domain.com<mailto:user@domain.com<mailto:user@domain.com>>> Using Outlook 5
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
A Created a new user account and the local account cannot see email Using Outlook 3
N How to set automatically the default or user defined Quickstyle Templates by Answer in Outlook Using Outlook 1
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Daniel Schunk User-defined form arrives empty at the recipient Using Outlook 3
C Changed By field not displaying individual user's name in O365 Shared Mailbox Using Outlook 9
M other user's mailbox won't open, forms disappeared Using Outlook 42
S Custom user fields in received messages Outlook VBA and Custom Forms 1
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
P Change PC User Directory & iPhone Sync Using Outlook 2
J Assess content of User Defined Field in Rule Using Outlook 3
M How can I determine which user read an email Exchange Server Administration 4
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14

Similar threads

Back
Top