Sending multiple attachments via Outlook from a table

[King Kreglo]

I have a report/quote where the users have a few option boxes to choose from and if they are selected, I want them to include those attachments when the email toggle button has been pressed, it sends the quote with the other selected documents included as well.

Here is the code that I am using to email the quote so far:

Private Sub tglEmail_Click()
     
DoCmd.SendObject acSendReport, , acFormatPDF, [Email Address], , , "Budgetary Pricing for" & " " & [Full Name], "Attached is a copy of your quote", True

End Sub

The attachments are stored in a separate table (tblattachments).
My thought is to have temporary variables that turn on when a document has been selected. Example: If([tempvars]![Document1]=2) Then add.attachment.

I've tried a few methods I have found on this site but they all chose attachments from files stored on their computer rather than already in the database.

Is what I'm trying to do possible and is there anyone that can point me in the right direction?