Table to Text File to Email to Text file to Table

[grande]

Is there a way that, when a user clicks a button, a table is converted to a text file and emailed?

Likewise, is there a way that, when a user clicks a button, a text file is converted into/appended to a table?

 

[grande]

By the way, I've been playing around with DoCmd.TransferText, and it says that I need a "Specification Name". Does anyone know what this is?

 

[PHV]

Take a look at the DoCmd.OutputTo and at the DoCmd.TransferText methods.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[grande]

PHV, do you know how to get Access to email through Lotus?

 

[PJStephenson]

Have a look in the FAQs or try thread707-691439

HTH
Peter

[η][β][π]