March 15, 2002 at 2:29 pm
I am using Access Project (.adp) as the frontend to a SQL2000 database. I have a button on a form that uses the SendObject command to email the report. Access always prompts for the output format which is always Rich Text Format. I have been trying with no success to include RTF in the code so I no longer have to select the format before the report is generated. Can someone please help me with the proper syntax for this? Following is an example of the code:
Dim stDocName As String
stDocName = "TestEmail"
DoCmd.SendObject acReport, stDocName
I would really appreciate any help I can get!
March 15, 2002 at 2:36 pm
Check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acmthactSendObject.asp
But basically
DoCmd.SendObject acReport, stDocName, acFormatRTF
should so the job.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply