emailing report?

[msto]

I want to email a customized invite to all emails in a query but I can't figure out how. I also want the report in the body of the email, not as an attachment. I know you can use mail merge and outlook but I am not using outlook for my email so how do I go about this? I thought it would be obvious but I guess not.

[June7]

Might be able to use CDO (Collaboration Data Object) code. https://codekabinett.com/rdumps.php?...access-vba-cdo

Including report in body of email is tricky. Could loop through records and build string of data with concatenation. Other than a signature card, embedding image in email is not something I have attempted. Could not be a PDF.