Subform email

[AJ]

I have a main form called ActionPlan and a subform called ActionItems. The
items on subform are Tasks assigned to a Resource with a DueDate. I have a
button on the main form that when clicked I'd like to have the ActionPlanRpt
generated and the Resources populated to the "To" on the email.

How would this be done? Thanks in advance.

 

[Arvin Meyer MVP]

The simplest way is probably to use SendObject, code for which you will find
in the help file. If you're using Outlook and you'd like to get a bit more
sophisticated, you can try the Outlook code at:

http://www.datastrat.com/Code/OutlookEmail.txt

 

[Chris Freeman]

Arvin,
I've been workign on this same setup, and everythjign works fine, except I
get the "A program is trying to send an email on your behalf. do you want to
allow this" message.

Is there any coding that will bypass this warning message? I can't add third
party softyware as some others have recommended, and I don't seem to have
this problem at home. At home I'm running Access 2002 with Outlook 2007. In
the office, I'm running completely Office 2003.

thanks

 

[Arvin Meyer MVP]

Microsoft changed the rules with Outlook 2007, so the problem may not occur.
With earlier versions, you can use Redemption which works extremely well on
any version of Outlook:

http://www.dimastr.com/redemption/

 

[AJ]

I don't know how to reference to pull the email addresses from the subform.

 

[Arvin Meyer MVP]

So, if the subform controlname is Sub1 and the email text box is named
txtEmail, the line of code would look like:

With objEmail
.To = Me.Sub1.Form.txtEmail

 

[AJ]

This works great for the email on the first record in the subform. How do I
make it populate the email of the resource in all the records on the subform?

Thanks for all the help.

 

[Arvin Meyer MVP]

You have to loop through the subform's recordset and send 1 email at a time.