Email Using VBA - Custom Sender Name

I have a Complaint Entry Userform that sends auto "Notification" email to selected recipients when the user clicks on "Submit" button. To make this work efficiently, I am trying to incorporate following:

1) The excel workbook is located on a public drive and is accessed by a no. of users. The auto email goes from individual user's Outlook with their name on it as sender.

I am wondering whether there is any way I can customise that Sender Name on email. So all the emails generated from this excel workbook will have a common sender name (e.g. "Customer Complaint system" or something..) rather than individual user names.

2) I have 9 fields on the userforms. I want to be able to pick the content from 2 of those field and include them automatically in the email Subject & Body.

e.g. In the worksheet (Name - "ComplaintData") where the entered information gets stored, I have "Complaint Number" in Coloumn A and "Customer Name" in Coloumn C.

I want to be able to have these 2 added to the Subject and Email Content....e.g. something like "A new complaint No. 60015 for XXX Trading Co has been entered!"