Send an email from a FORM using Microsoft Outlook

[pjtessi9]

Hi folks,
When I am in a FORM, I want to be able to click on a button and send an email using Microsoft Outlook.
But I also want to include an attachment that is stored in the database and accessible in the FORM (normally the attachment is a .docx file or a PNG file).

I have found some vba code and everything is working fine except I cannot add the attachment in the email.

Can some one help me writing the propre vba code to add the attachment in the email.

I have included a sample database so you can see what I mean and the vba code I found and wrote.

The form is named frm_McNeil
The table containing the attachment is McNeil

Thanks for your help. :-)

[June7]

Attachment would have to be saved out to folder location then attached to email using Outlook automation, not DoCmd.SendObject. This is a common topic.

Example code to save attachment to folder: https://docs.microsoft.com/en-us/off...ile-method-dao

Example code to automate Outlook and attach a file: https://vbahowto.com/2020/04/28/how-...0automation%29

[Welshgasman]

I have google on this phone.
https://www.google.com/search?q=add+...e-gws-wiz-serp