Automating Text File Export

[Guest]

Hi have successfully been able to send excel files by using the code
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97
..To = EmailAddress
.Subject = EmailSubject
.Body = EmailBody
.Attachments.Add (TextFileNameMyFile)
However when I attempt to change to a text file I receive an "unknown file
format" error.
Can anyone point me in the right direction? I am currently running XP

 

[Dirk Goldgar]

Hi have successfully been able to send excel files by using the code
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97
.To = EmailAddress
.Subject = EmailSubject
.Body = EmailBody
.Attachments.Add (TextFileNameMyFile)
However when I attempt to change to a text file I receive an "unknown
file format" error.
Can anyone point me in the right direction? I am currently running
XP

Please post the actual code that is raising the error, and indicate on
which line the error is occurring.

 

[Guest]

Thank you, I have solved the problem.

Please post the actual code that is raising the error, and indicate on
which line the error is occurring.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)