Ok I have made other post regarding thsi problem, So here it is I am going to give the scenario and scatch the fact that i have any code for this at all. If more information is needed please tell me.
Main Form = dbo_project
Subform = Bidders_Subform
I am placing the control to run the code on the main page. The Subform is filtered so that only members that have looked at the project on the main form are displayed. Main form has all the project information. Subform Has Name / Company/Email Displayed. I would actually like to not display the email in the form (not really a needed since the records are edited in another form). No editing is allowed on the subform.
So here is what I need. A Control (Button) that when clicked takes all the emails in the subform and places them into outlook. This has been a nightmare for 2 weeks, I probably confused people with my bits of code in earlier posts. So I am asking for a fresh solution started here.
Main Form = dbo_project
Subform = Bidders_Subform
I am placing the control to run the code on the main page. The Subform is filtered so that only members that have looked at the project on the main form are displayed. Main form has all the project information. Subform Has Name / Company/Email Displayed. I would actually like to not display the email in the form (not really a needed since the records are edited in another form). No editing is allowed on the subform.
So here is what I need. A Control (Button) that when clicked takes all the emails in the subform and places them into outlook. This has been a nightmare for 2 weeks, I probably confused people with my bits of code in earlier posts. So I am asking for a fresh solution started here.
