Your question is not clear as to how you are automating this process. Are you using VBA to create the report in MS Access? How about to launch Lotus Notes and attach the report? Assuming that you are using VBA, then should have no trouble using the Send method in LotusScript. Here is an example from the Lotus Notes Developer Help.
Dim session As New NotesSession
Dim db As NotesDatabase
Dim doc As NotesDocument
Set db = session.CurrentDatabase
Set doc = New NotesDocument( db )
doc.Form = “Memo”
doc.SendTo = “Elissa Minty”
doc.Subject = “Here’s the document you wanted”
Call doc.Send( False )
If you still have questions, post the code that you are using to add the report.
Hope this helps