Export from a Form to delimited txt or csv

[Jeffx]

Currently run a database for a conference we run Access 2003 DB using Access 2007 to run. I have added a button (with some vb code via the click event procedure) to open two word docs that I want to populate with the information that is on the currently open record in the form (basically a receipt letter and letter of account or statement). I have thought of many different way to doing this, and whilst I am open to suggestions, I thought I would try and create a text file with some vb code from the same button that opens the word docs and make the word docs a mail merge with the text file or csv. My problem is that I haven't found the necessary vb code to export the data from a single record in an open form (nb: some of the things I want to export from the from are calculations and not info populated from a table.

Any help with the code or another idea would be appreciated.

 

[Jeffx]

Phil

Thanks for the code. Will work through it to implement in my DB.

Will let you know how it goes, looks pretty good though and easy to understand.

Thanks again

Jeff

 

[Jeffx]

Pat

Adjusted the code, works a treat.

Thanks for your help

Jeff