Access Access send object

[mmahoney123]

Good afternoon,

I am trying to use the send object option to create and send an email with an excel attachment from a query I have created.

Unfortunately, the data format is incorrect. I need the file to show 08/11/2011 but it is showing
08-Nov-11

I can get the date format to work if I use the transferobject option but not when I use the send object option.

Any help is appreciated.

Regards,
Mark