TransferText in 2007 with macro

[AFSSkier]

In 2003, I have a macro that exports a tab delimited file using the
TransferText action. I've converted to 2007, this is not available. What do
I need to do to be able to export this file? Also, is it possible to email
this same tab delimited file?

 

[AFSSkier]

I converted the old macro to code & TransferText will work in 2007.

I have the following code to export a Tab Delimited file using a Tab Export
Spec. But how can I email the same Tab Delimited format?

Code:
DoCmd.TransferText acExportDelim, "Auth_item(Tab) Export Spec",
"auth_item", "\\Slcinternet\CLS\auth_item.txt", False, ""

'Here's were the code needs to change to reflect emailing the Tab Delimited
file.
DoCmd.SendObject acTable, "auth_item", "MS-DOSText(*.txt)",
"(e-mail address removed)", "", "Authorized Items", "Per your request, attached is a
copy of the updated flat file.", True, ""