SendObject to Multiple Companies with Macro

  • Thread starter lintonneedsyourhelp
  • Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top