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
Bookmarks