So you need a code/ function for generating the txt file...
For sending the email there is one command that yo c use in Ms Access and I don't think that it is a problem
For your generation code see this exemple and commands inside:
Width # Statement Example
This example uses the Width # statement to set the output line width for a file.
Open "TESTFILE" For Output As #1 ' Open file for output.
Print #1, "Name: " , Forms!Myform!Name
Print #1, "Position: " , Forms!Myform!Position
Close #1 ' Close file.
Those exemple is taken from Access Basic help! All the commands are described there!
Have a nice day!
|