sent 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, "(e-mail address removed) ",
, , "Trends", , False

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

 

[pietlinden]

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, "(e-mail address removed) ",
, , "Trends", , False

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

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]

hi are you

 

[Pieter Wijnen]

you're seriously starting to bug us

Pieter