Sending an email in a form

[Alaska1]

Hello,

I am trying to set up and control form send an email on click on. What is the best way to do it? Is there a Macro to use or should I build in code? I would like it to open to outlook.



Thank you!

[June7]

SendObject method is available in macro as well as VBA.

If that does not meet your requirements, use Outlook automation in VBA.

[Alaska1]

SendObject method is available in macro as well as VBA.

If that does not meet your requirements, use Outlook automation in VBA.

Thank you for your reply. I tried the SendObject method. Will that allow me to populate the email address or I have to use the outlook automation?

[June7]

Which email address? The From:? That will require automation. It uses SendOnBehalfOf property. https://www.slipstick.com/developer/...l-address-vba/