![]()
strbody = "A repeat repair assigned to your team has arrived at the workshop," & "<br> " _ & "Please update the tracker " & "<a href=""Z:\WORKSHOP\Repeat Repair Tracker.xlsx"">here</a> and treat the job as a matter of urgency," & "<br>" _ & "Thank you." UserFormBody = "<br>" & "<br>" & "WIP Number: " & UserForm1.TextBox1 & "<br>" & "Previous WIP: " & UserForm1.TextBox2 & "<br>" & "Number of visits for this repair: " & UserForm1.TextBox3 & "<br>" & "Service Advisor: " & UserForm1.ComboBox1
Bookmarks