Help with code for SendObject?

J

jo

Hi I would like to send email as the report has been opened. Maybe by on the
On Open event of the report???
I have tried the following code but it comes up with errors such as "Complie
Error, Invalid use of property" it highlights "acSendReport". Can you help
please?
Jo


Private Sub Report_Open(Cancel As Integer)
DoCmd.SendObject
acSendReport , "Overdue", , "(e-mail address removed)", , , "Overdue
Gauges!!"

End Sub
 
J

jo

Hi Jill thaks for the reply I tried acReport but it is still coming up as a
Compile error? Have any more ideas please?
Thanks
Jo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access/Lotus Notes 2
SendObject 3
SendNotesMail?? 18
VBA Coding Help for Beginner 0
SendObject doesn't find fields in querry 1
A problem with SendObject 2
SendObject problem 3
SendObject to send email 2

Top