Export a report (Access 2003) to my desktop in rtf format.

[Rick West]

I can export a report using the File, Send To, Mail Recipient, (Select Format) rtf, but would like to automate this process in a single button click.



It would always export to my desktop and always in rtf format.

How can I do this?

[dcrake]

Then create a macro or vba code and place it on the onclick event of a buitton. Simple

[Rick West]

Simple is relative, I'll let you know soon how simple it was. Thanks for leading me in a direction. Beats trial and error. I appreciate it.