sent to email

P

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, "[email protected] ",
, , "Trends", , False

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

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, "[email protected] ",
, , "Trends", , False

But is it possible to do it with the Transfertext command ?
Click to expand...

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).
 
Top