Generate file and e-mail it?

[homer09001]

im trying to make a script that will pull user details from a database and create a file and e-mail it to a user.

i know how to create a basic e-mail script but i don't know how to 1) get it to attach a file to the e-mail.
2) create the file for the e-mail without saving it on the server?

would anyone be able to point me in the right direction?

[Horizon88]

Does it need to be in a separate, attached file, or is this a situation where a plain-text email containing the information would be sufficient?

[homer09001]

it needs to be in a file, as it is downloaded and uploaded to other sites.

[homer09001]

i have thought of a way of creating the file, i simply create it as normal send the e-mail then delete the file, its just im still stuck attaching the file to the e-mail.