Really thanks again Miguel, will try on the new Macro with actual data.

Dear Miguel,

I try the macro with  live data, but File name still can not be attached in subject. Pls help further

So far no error code prompt, related attachment file can be loaded only File name do not appear in subject of the Email...

Thanks Miguel, problems finally fixed, ie file name retained in subject thanks support!