Exporting Query to RTF

[smilla]

Hi there,

Can anybody tell how to export the data from a Query to RTF via VBA or Macro?

I have tried TransferText from a macro but this comes up with an error "cannot update. database or object is read-only".

Any ideas.

Thanks
Smilla

 

[KenHigg]

Have you tried the OutputTo method of the docmd object in vba?

Or you can do OutputTo from a macro...

Ken

 

[smilla]

Thank you, but how can I overwrite the existing file without the message box coming up. I want to do this over night so it doesn't disturb the users.
Smilla