I've created a workbook that -when opened- opens a userform while hiding the workbook.
It's a simple userform used to inform the workshop of a repeat repair visit.
All the service advisors have to do is type in the current job number, previous job number and number of visits for the same complaint, then select service advisors name and team leaders e-mail from drop down lists.
It then emails the selected team leader with the information.
I originally only had the details from the userform laid out as follows in the email;
"A repeat repair assigned to your team has returned to the workshop, please update the log and blah blah blah..."
WIP Number: 12345
Previous WIP Number: 12344
Service Advisor: xxxx
My code for this worked fine, it set everything out as it should, I then decided it would be better if I embedded the link for the 'log' in the email and now that I have done that, it has messed up the layout of the email.
I can't seem to introduce a new paragraph between the text and information from the userform and even the new lines in between WIP number, Previous WIP etc. have stopped working.
I've tried vb New Line, vb CrLf etc. but i can seem to get anything to work.
Anybody have any ideas what else i could try?
I am trying to get it to look like this...
A repeat repair assigned to your team has arrived at the workshop,
Please update the tracker here and treat the job as a matter of urgency,
Thank you.
WIP Number: 12345
Previous WIP: 12344
Number of visits for this repair: 2
Service Advisor: xxxxxx xxxxxx
Bookmarks