Emailing a File

  • Thread starter Thread starter Steven M. Britton
  • Start date Start date
S

Steven M. Britton

I am trying to find out how I can automatically grab a
specific file from my computer and attach it to an email.
The code I currently have is:

DoCmd.TransferText
acExportDelim, "qryExport_Dazzle", "qryExport_Dazzle", "C:\
DazzleExport.txt"
Name "C:\DazzleExport.txt" As "C:\DazzleExport.csv"

Now I want to add the line to grab that file and email it
to my customer, I don't know that the SendObject works
does it? Or is it only for objects still in the database.
Any help would be nice, thanks

-Steve
 
SendObject does work, but has some limitations. For
instance, it will export data, however it will name the
file as the object exported (ie: QueryName) and send it in
the format used as the option supplied (acFormatXLS).
 
Back
Top