I've looked all over this forum and tried several different methods to do the same thing, but I can't get any of them to work for my application (most likely because I don't know what I'm doing). Here's what I would like to do;
On my form is a checkbox option group. When I check the "Yes" box (build code in "Got Focus") I would like to open a new mail message using Outlook (preferably with the autosignature that shows up at the bottom when I normally click "New Mail Message", but that's not a deal-breaker).
I need to send the message to Smith, John; Jones, Doug; and a name field from my form, Me.Supv (the names are from my work intranet, and that's how they normally show up in the "To:" box. I tried entering the full e-mail addresses in the code too, but nothing showed up in the "To:" box either way I tried).
The subject should be another field from my form, Me.Type.
The body of the e-mail is also from my form, Me.Sent1, Me.Sent2 & Me.Sent3.
Lastly, I don't want the e-mail to be sent until the user manually clicks the "Send" button. They may need to add pictures as an attachment in some cases.
I've just started learning VBA coding, and trying to understand how to apply other people's code to my situation is beyond me. I hope to learn enough so I don't have to keep bothering you guys, but that is still a bit in the future.
Thank you for all of your help in the past, and again today.