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 ?

 

[JerryKlmns]

The ObjectType of the SendObject method has an AcSendObjectType enumerator of acSendQuery. Have you tried it?

Of course there is the CDO send message way (thread707-1307181) and the classic Outlook Automation way (with the Outlook Object Model Guard for 2000sp2 and above versions).