Send Mail

[Dimitris Nikolakakis]

I have a form and I have put two buttons

1. to send the result of a report to an e-mail
2. to export the result of a query to a text file (always c:\order.txt)

For number (2):

I want, after the file is created, to send it by e-mail. Is there any way to
do it? Or I have to go to OUTLOOK and do it maually?

thanks

 

[Jim/Chris]

You can create a macro and use the sendobject command

Jim

 

[Dimitris Nikolakakis]

for number 2 I have used the TransferText method.

If I use the SendObject it means that I have to select an object from the
database and the file that I create (c:\orders.txt) is not an object of DB.

Can I do something else?

thanks