Unanswered: Export a Table as CSV and send via email
I would like to export the contents of a table in CSV format and email it to a recepient regularly. As I understand, a text file can be createed but not quite csv. I used the following code to create txt attachment. Could someone help me amend this code to attach in CSV format.
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Const FILE_SPEC As String = "C:\Temp\File.txt"
Const TABLE_NAME As String = "tblPtojects"
DoCmd.SendObject acTable, "tblProjects", acFormatTXT, "Email Address", , "Design Variationss", "Attached is the report showing all design variation requests that have been approved over the past three months." & _
& vbCrLf & "Cheers" & vbCrLf _
& vbCrLf & "AK", True