+ Reply to Thread
Results 1 to 2 of 2

Sending Email to Multiple Recipients w/ High Importance

Hybrid View

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Arizona
    MS-Off Ver
    2013
    Posts
    6

    Sending Email to Multiple Recipients w/ High Importance

    Hello! I'm attempting to edit a macro for an employee order form and am fairly unfamiliar with VBA.. I wrote this initial code and have been struggling to edit it since..

    I need to send the file to 2 recipients and can't figure out how. CC would also be appropriate. I would also like to add high importance but have been unable.

    The code is as follows...

    Sub ExecSubmitFile()
    '
    ' ExecSubmitFile Macro

    If Range("r1") = "" Then
    MsgBox ("The name field cannot be blank. Please complete the top of the order form.")
    Range("r1").Select

    Else

    If Range("s2") = "" Then
    MsgBox ("The Location field cannot be blank. Please complete the top of the order form.")
    Range("s2").Select

    Else

    If Range("r3") = "" Then
    MsgBox ("The Department field cannot be blank. Please complete the top of the order form.")
    Range("r3").Select

    Else

    Dim wb1 As Workbook


    Dim address, Name, Loc

    address = Range("l3").Hyperlinks(1).address
    address = Mid(address, 8)
    Name = Range("r1").Value
    Loc = Range("s2").Value

    Set wb1 = ActiveWorkbook

    wb1.SendMail address, "EXECUTIVE Order - " & Name & " " & Loc, True


    On Error Resume Next



    With OutMail
    .display
    .OriginatorDeliveryReportRequested = True
    .ReadReceiptRequested = False

    End With
    On Error GoTo 0



    With Application
    .ScreenUpdating = True
    .EnableEvents = True
    End With
    Range("A1").Select
    ActiveWorkbook.Close
    End If
    End If
    End If
    End Sub

  2. #2
    Registered User
    Join Date
    05-19-2015
    Location
    Arizona
    MS-Off Ver
    2013
    Posts
    6

    Re: Sending Email to Multiple Recipients w/ High Importance

    Mods Please Delete.. Mistakenly posted twice. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can't set OL Importance to HIGH
    By DonW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2013, 04:41 PM
  2. Replies: 0
    Last Post: 09-22-2012, 10:06 AM
  3. Change Case of recipients name when sending email
    By marcusjb in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2012, 09:36 AM
  4. [SOLVED] Set an Excel generated CDO email's priority or importance to 'high' or'highest'...
    By Kevin Lyons in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2005, 02:05 PM
  5. Replies: 1
    Last Post: 01-13-2005, 02:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1