Create email message from ms access db

[Almi]

Is it possible to create email message ( body of message , not attachment to email) from data stored in ms access db.?

Namely , I know how to send report as attachment but I would like to create body of email message with soma data from ms access db?

[ItsMe]

Yes, reference Outlook in Access' reference library, create objects to be instantiated as an Outlook Email. Interact with Objects. Another option is CDO.

Here is an example of interacting with Outlook using late binding, where referencing the library is not needed.
https://www.accessforums.net/access/...tml#post207019

[orange]

Sure. Try Google MSACCESS EMAIL Body FROM database

You didn't mention Outlook, but here's a link http://www.blueclaw-db.com/access_em...nd_outlook.htm

[Almi]

Yes, reference Outlook in Access' reference library, create objects to be instantiated as an Outlook Email. Interact with Objects. Another option is CDO.

Here is an example of interacting with Outlook using late binding, where referencing the library is not needed.
https://www.accessforums.net/access/...tml#post207019

Thank you, but second option seems to be too advanced for me.

[ItsMe]

You mean CDO is too advanced? What have you tried and where are you stuck?

You do not have to add an attachment using DoCmd.
https://www.accessforums.net/program...tml#post218796