Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 04-16-2015, 02:18 AM
gmayor's Avatar
gmayor gmayor is offline Create a Userform in Outlook to select a macro for an email template. Windows 7 64bit Create a Userform in Outlook to select a macro for an email template. Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If you are running the userform in Outlook, there is no need to create an Outlook application. You already have one and you are using it.

Code:
Option Explicit

Private Sub CommandButton1_Click()
    If Me.OptionButton1.Value = True Then
        Me.Hide
        MsgBox "OptionButton 1 was selected"
        Call Email672200        ' Module 2
    End If
    If Me.OptionButton2 Then
    Me.Hide
        MsgBox "OptionButton 2 was selected"
    End If
    Unload Me
End Sub
Sub Email672200()
Dim Outmail As Outlook.MailItem
Dim olInsp As Outlook.Inspector
Dim wdDoc As Object
Dim oRng As Object
    Set Outmail = CreateItem(olMailItem)
    With Outmail
        .BodyFormat = olFormatHTML
        .To = "672200"
        .CC = "672200 CC"
        .BCC = ""
        '.Attachments.Add ""
        .Display
        .Subject = "672200 - Escrow Shortage Account"
        Set olInsp = .GetInspector
        Set wdDoc = olInsp.WordEditor
        Set oRng = wdDoc.Range(0, 0)
        oRng.Text = "Hello Everyone"
        
    End With
    On Error GoTo 0
    Set Outmail = Nothing
End Sub
Private Sub CommandButton2_Click()
    Unload Me
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 

Tags
radio button, templates, userform



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a Userform in Outlook to select a macro for an email template. Agenda template - userform kennyD Word 4 04-07-2015 01:32 PM
Create a Userform in Outlook to select a macro for an email template. Create macro program to automatically email outlook with a visible cell range BillMaintenance Excel Programming 19 03-11-2015 03:19 PM
Create UserForm ComboBox or ContentControl ptmuldoon Word VBA 11 01-17-2015 05:58 PM
How to get Outlook 2007 userform into template? Royzer Outlook 0 04-13-2012 10:41 AM
Can't create new email or access email acounts Outlook 2003 onthebeaches Outlook 1 02-20-2012 10:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft