Sending TransferText delimited file by email from code

[Guest]

I have a macro that performs a query and populates an empty file with
records. It then exports the results to a text file via the TransferText
function. I use a specificatioin file to format the text file. I want that
text file emailed. There is a pulldown menu box in the macro design to Send
an Object, but not a delimited text file. I can select the resulting table as
an object, but then it does not allow me to indicate a specification file. I
have an option to send the table as a text file, but it sends it as an MS-DOS
Text file. How can I perform that send specifying the format?

 

[John Nurick]

Hi Ray,

There's lots of information about sending emails from Access in Tony
Toews's page at http://www.granite.ab.ca/access/email.htm

 

[chenxiao]

dsfdsgfvdsaff