SendObject not working the way I want

[Smudger]

Hi,

I am using SendObject in a Macro to send a table to a list of mail addresses (This list will not change so I have hard coded it into the macro).

My problem is that I want the subject line to read 'date'(in format DD MMM YY HH:MM) and then "Provision report"

I only tend to work in macros so I do not understand VBA that well.

Can someone please help me?

Thanks