I am trying to email a report using the following code using office 365 Access vba and Outlook. It is working but I can't figure out how to add the report "MyReportR" as an attachment without first saving it as a file. Here is my code I got from the Send Email Template.

Details

    Dim msg As String
    msg = "My CareGiver Report"
    
    Dim o As Outlook.Application
    Dim m As Outlook.MailItem
    
    Set o = New Outlook.Application
    Set m = o.CreateItem(olMailItem)
    
    With m
        .BodyFormat = olFormatHTML
        .HTMLBody = msg
        .To = Email
        '.CC = "[email protected];[email protected]"
        '.BCC = "[email protected]"
        .Subject = "My CareGiver Report"
        .Display
        
    End With

    Set m = Nothing
    Set o = Nothing