send to email

[peljo]

I have to send a query in cvs format to my ;ogistics centre.With the help of the forum i succeeded to do it :
DoCmd.TransferText acExportDelim, "qryDocExportSpecification", "QryDocs", "QryDocs.csv"

My question is, can i email this directly ? The same as the sendobject command like :
DoCmd.SendObject acSendReport, "rptSchedule", acFormatSNP, "tgkn@gmail.com ", , , "Trends", , False

But is it possible to do it with the Transfertext command ?

 

[CEH]

DoCmd.SendObject [objecttype],[objectname],[outputformat],[to],[cc],[bcc],[subject],[messagetext],[editmessage],[templatefile]