Mail report as HTML--Attachment name ?

[ciskid]

Hi Folks

I have a command button on a form that emails a report.

The report is based on a query called Main query.

When the email client fires up its attaching the report as main query.html

I would like to specify the name of this report to mean something else.

Can anyone give me some advice on this ?

Maybe Daily Report dd/mm/yy.html

Any help and information is appreciated.

Cheers

Jimmy