L
lintonneedsyourhelp
I have a table for companies with each company having up to three email
addresses. I can put the three email addresses in 1 field with commas or 3
separate fields (doesn't matter for anything else).
I have a table for projects they are involved with that has a field for
keeping track of which companies are involved. Currently, this is done with
a combo box on a form.
I want to make a form that has a drop down box containing the projects that
allows a user to select a project and hit a button that runs a macro. Here's
where my knowledge runs short and I need help: How do I make the macro get
the project name from the form, lookup the companies involved with it, and
fill in their email addresses in the email?
I'm flexible on how this is structured and ALL advice is greatly
appreciated. I did not get notified of replies on this forum once before, so
here's my email address just in case: linton at saklas dot com
Many thanks in advance! The knowledge on this forum has helped me a great
deal so far.
addresses. I can put the three email addresses in 1 field with commas or 3
separate fields (doesn't matter for anything else).
I have a table for projects they are involved with that has a field for
keeping track of which companies are involved. Currently, this is done with
a combo box on a form.
I want to make a form that has a drop down box containing the projects that
allows a user to select a project and hit a button that runs a macro. Here's
where my knowledge runs short and I need help: How do I make the macro get
the project name from the form, lookup the companies involved with it, and
fill in their email addresses in the email?
I'm flexible on how this is structured and ALL advice is greatly
appreciated. I did not get notified of replies on this forum once before, so
here's my email address just in case: linton at saklas dot com
Many thanks in advance! The knowledge on this forum has helped me a great
deal so far.