If people don't open the mail, then they can't read it.

I suspect what you are talking about is the preview feature...  There, it
depends on the mail client and the type of attachment. Mozilla Thunderbird,
for instance, does show pictures in preview that were attached. It doesn't do
the same for PDF files though, or Word documents, or most other files.
So unless the recipient's e-mail client has an Access preview filter - and I
am not certain those even exist - I don't think there's anything you can do.
Unless maybe you can turn your report into a picture file.  Or an HTML file.
Or even plain text if you don't have graphical elements in your report.
Most, if not all, modern e-mail programs can show those file types in
preview without you having to click on the attachment.

Of course there may be other, better ways to address your problem, but this
is all I can think of.

Yes, you can put a report in the message of an outlook email but, this took
me a while to get working right.  This is the onclick event.  You will need
to adjust your report to that it looks right.

DoCmd.OutputTo acOutputReport, "Name of report", acFormatRTF,
"fullpathofreport.rtf"
     
   Dim wdApp As Word.Application
   Dim doc As Word.Document
   Dim Report As MailItem
   
   Set wdApp = New Word.Application
   Set doc = wdApp.Documents.Open("fullpathofreport.rtf")
   txt = InputBox("Add any comments or message.", "Input Box For Email
Comments.")
   doc.MailEnvelope.Introduction = txt
   Set Report = doc.MailEnvelope.Item
   
   Report.To = "emailaddress"
   Report.Subject = "whateveryouwant"
   Report.Send
   
   wdApp.Quit False
   Set doc = Nothing
   Set wdApp = Nothing
   
   --
Jeff C
Live Well .. Be Happy In All You Do