Attach multiple reports automatically to an email from Access

K

Ken Smith

The following code:

DoCmd.SendObject acSendQuery, "NewSR5data", acFormatXLS, _
"[email protected]", "", "", _
"Assembly " & Forms("Assembly Documentation Menu
B").SubjLine, _
"DO NOT EDIT EMAIL SUBJECT LINE", intSeeOutlook

emails the file attachment "NewSR5data.xls" to "[email protected]"

If its possible, what would the code string look like to email several files
based on different queries to this one email?
 
Top