Perhaps something like this:
DoCmd.SendObject acSendTable, "Table1", acFormatXLS, _
"someone@somewhere.com" _
,,,"Here's ya table", "Attached find Table1", True
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Andy48" <Andrew@ajgreen1953.fsnet.co.uk> wrote in message
news:1112010823.902468.314770@g14g2000cwa.googlegr oups.com...[color=blue]
> Hi everyone,
>
> Can anyone point me in the direction of how to export a table, in
> excell format automatically via E-Mail?
>
> regards
>
> Andy48
>[/color]
Code to export a table via E-Mail 
