Need code to send reports from Switchboard

[Guest]

I have DB where I want to e-mail mulitple reports (about 7) to a single
distribution list. I want to do this via a button on a Switchboard - I click
button and e-mail pops up with reports attached. I can do
this with a single report via a command button on a form, but how do I get
multiple reports to do this from a Switchboard button? I'm thinking that I
need to
create VBA code (I would need serious help here) and attach it to the
Switchboard button (Can this be done?).

Your assistance is invaluable. Thanks in advance.

 

[Guest]

hi
here is code to send mail that i have attached to a button.

Private Sub cmdSendeMail_Click()
On Error GoTo Err_cmdSendeMail_Click
Dim stDocName As String
stDocName = "rptVMDForm"
DoCmd.SendObject acReport, stDocName, "RichTextFormat
(*.rtf)"

Exit_cmdSendeMail_Click:
Exit Sub
Err_cmdSendeMail_Click:
MsgBox Err.Number & Err.Description
Resume Exit_cmdSendeMail_Click
End Sub

look up send object method in help for more info.

 

[Guest]

I understand how the stdocname sets to a single report. How does this send
multiple reports? Thanks for helping.

 

[Guest]

dab1477,
Have you found a solution to this yet? I have the exact same issue and was
hoping you had a solution. If I find one in the mean time I will reply back
to this for you.