Exporting from Access to Outlook

[pbisaillon]

Hi, is it possible to export out of Access and have the .TXT file automatically attached to an Outlook email message? Below is the code that I have for the command button to have it export to a directory, but I would like to have it launch Outlook, and attach itself to an email.

Any tips would be great.

Private Sub Command42_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

MsgBox Prompt:="This will export the Box Level Data to be imported into iRIMS. Please notify Patrick Bisaillon at 873-7231 so he can import the information into iRIMS.", Buttons:=vbOKOnly, Title:="Box Export"

DoCmd.TransferText acExportDelim, "QRY_GNWTBOXEXPORT Export Specification", "QRY_GNWTBOXEXPORT", "J:\Public Works and Services\Box Export Data\GNWTBOXEXPORT.TXT", False
End Sub


Thanks,
Patrick