Using Access 2000. I have VBA code gather stuff into a table. Currently, the user then manually saves the contents of that table into a Word Merge doc by right clicking the table and clicking Export and saving it as a Word Merge file.

I'd like the same Sub from the command button click to popup the Export Table window using that table (and if possible have Word Merge type selected by default). Is this possible?

I'd also like the vba code to open the table for the user to preview. Maybe make it open the table for preview, then popup a msgbox asking "do you want to save this table?"

I don't have time right now to research this, but Chapter 11 (Working with Word) in "Expert One-on-One: Microsoft Access Application Development" covers this issue, I think.

Anyone else?

mmcdonal

I got more or less what I need using DoCmd.TransferText... found it through google; I guess my first search wasn't thorough enough.

Thanks !

Even better, I just found this KB article explaining how to use the Windows Common Dialog. Good Stuff

http://support.microsoft.com/default...b;en-us;303066