Subform email

  • Thread starter Thread starter AJ
  • Start date Start date
A

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,
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
 
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
 
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.
 
Back
Top