On one of my sheets I currently use this code to send an email to a know address. What I want to do is alter this code so that rather then simply sending a message, the user will have to enter the recipients of which to send to...
Thanks for the help!
With ActiveWorkbook .SendMail Recipients:="[email protected]", Subject:="Car # " & Sheets("EmPr").Range("CG2 ") & " is attached and awaiting your approval to be closed." .Close SaveChanges:=False End With
Bookmarks