Send excel file to outlook

Hi,

I need to create a function to send excel file into outlook email. I manage to create that function but the only problem now it does not call the specific "filename" as i already set it inside the macros. It supposed to save as below:

RandomNo-ApproverMap-RequestorName-VendorName-Date-Time.FileType

198470 - 5078 - Form Testing - - 181114 8'35am.xlsm *It does not call Requestor and VendorName

Can anyone help to me to check my macros if there is something left. TQ in advance.