sent to email

  • Thread starter Thread starter peljo
  • Start date Start date
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, "(e-mail address removed) ",
, , "Trends", , False

But is it possible to do it with the Transfertext command ?
 
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 ?
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).
 
Back
Top