Results 1 to 4 of 4

Send email via Excel button.

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2007
    Location
    Charlotte, NC
    Posts
    31

    Send email via Excel button.

    I have an Excel spreadsheet/form that once completed by user, they click a button to send an email to a help desk, with the form.

    I would also want the person who is filling out the form to receive an email.

    How can I add to the below code??
    >>>>>>>>>>>>>>>>>>>>>>>
    Sub Macro3()
    
        ActiveWorkbook.HasRoutingSlip = True
    
          With ActiveWorkbook.RoutingSlip
            .Recipients = "[email protected]"
            .Subject = "Routing: New Owner Form"
            .Message = _
            "Your Request has been received and will be added as a New Owner!"
            .Delivery = xlAllAtOnce
            .ReturnWhenDone = False
            .TrackStatus = False
          End With
    
        ActiveWorkbook.Route
        ActiveWindow.SmallScroll Down:=-9
        Range("E7:M7").Select
    
        MsgBox Prompt:="Email has been sent to Portfolio User Support" & myVar, _
        Title:="Confirmation", _
        Buttons:=vbOKCancel
      
    End Sub
    Last edited by Leith Ross; 11-07-2007 at 12:53 AM.

Thread Information

Users Browsing this Thread

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

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