Send Email by VBA

[rgsw]

Hello - I have a query which I open in a form that has selected emails from a yes/no field. I now manually copy those email addresses and paste them into my outlook then type message. I would like to somehow have VBA do that for me. Any suggestions? Thanks!

[matrekz42]

Hello - I have a query which I open in a form that has selected emails from a yes/no field. I now manually copy those email addresses and paste them into my outlook then type message. I would like to somehow have VBA do that for me. Any suggestions? Thanks!

There is a lot of code for this in Google, also a lot of situations that are different for each user, and if you are literally going to be in front of the machine to hit the security messages, or if you want the code to do that for you.

Let me know and I can dig something up.

[DonRayner]

This should set you on the right path

http://support.microsoft.com/kb/161088

[rgsw]

There is a lot of code for this in Google, also a lot of situations that are different for each user, and if you are literally going to be in front of the machine to hit the security messages, or if you want the code to do that for you.

Let me know and I can dig something up.

Thanks for everyone's reply. To answer matrekz42 I'm really not sure - I suppose I would want VBA to do it all.