Sending Charts in Body of Email from Access

[MCTampa]

I have a database from which I have created four graphs in a form and would like to either embed the form in its entirety or the individual charts in the body of an email.
I had been downloading the data to Excel and pasting the graphs into the body of an email, but I would like to make the process more efficient and send directly from Access.
I do have a few databases from which I email reports as attachments, but for this project, I want to send the graphs directly in the email body.

I have absolutely zero idea how to do this, but know that the DoCmd.SendObject method will not work.
Any suggestions would be great.

Thanks,
Mike

 

[Micron]

My experience with Access charts was to send them as a report, and reports are much more conducive to emailing IMO. Forms are not for printing or sending. Regardless, my experience with Access charts makes me think I'd rather rub sand in my eyes than deal with them. Perhaps things have changed since then but I doubt I'll ever know.

 

[MCTampa]

While I agree with you, I'm trying to make this a one-stop shop for the data and charts so I can turn it over to an associate to run.

 

[Micron]

Was going to write that I don't see how you can send a chart in an email body unless it is an image. However, I do see that in Outlook 2016 you can insert a Microsoft Graph object into an email. If Access is using the MS graph object that might be a way to do it, but to do so from Access would require the use of Automation with Outlook. IIRC, the issue of not having Snapshot viewer is no longer, and if that is the case, I might be asking those who want an embedded graph in an email why they can't just click on an attached report to look at the graph - if they ranked higher than me. If not, I'd probably tell them that unless they get approval for a 'project' for me to take the time to learn some other method, that's life and deal with it. My problem was always that while I was developing databases, I was always expected to do my regular job as well, so I didn't always have the luxury of delving deep into complicated design concepts.