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 ?
pietlinden@hotmail.com - 10 Sep 2007 01:42 GMT
> I have to send a query in cvs format to my ;ogistics centre.With the help of
> the forum i succeeded to do it :
[quoted text clipped - 10 lines]
> --
> Message posted viahttp://www.accessmonster.com
Probably the easiest way to do it is to use CDOSys to automate e-mail.
You can't attach an external file with SendObject...(IIRC).
HELENA SMITH - 29 Sep 2007 02:33 GMT
hi are you
> I have to send a query in cvs format to my ;ogistics centre.With the help of
> the forum i succeeded to do it :
[quoted text clipped - 7 lines]
>
> But is it possible to do it with the Transfertext command ?
Pieter Wijnen - 29 Sep 2007 19:38 GMT
you're seriously starting to bug us
Pieter