I'm wondering if I can set the "Rich Text Format" as an default when the "Mail report" button is pushed. Right now I need the user to pick RTF, is there a way to eliminate user interaction?
Thanks.
Now it's saying that the format in which you are attempting to output the current object is not available.
Am I doing something wrong?
This is my code:
Dim stDocName As String
stDocName = "rptRequest"
DoCmd.SendObject acReport, stDocName
where do I put that , acFormatRTF at?