Automatic email

[access_novice1234567]

Hello.
I have a form that users log product concerns on. When a new concern is logged, I want the manager of that product to be informed, automatically by email.
In "Team" table I have all the products, managers and email addresses stored.
In "ConcernInputForm" when the user inputs the project name I have a lookup command entering the manager name and email address automatically. How do I get the email address into my macro automatically? It needs to look at the field Email_Address I think?

Also, the form generates a concern log number, which I would like to include in the email.

Any help is appreciated

 

[ted.martin]

There is a lot of information on this forum to help you do what you request. This link will help too. http://www.access-programmers.co.uk/forums/showthread.php?t=141517

You will need to include the Concern Log number in the body of the eMail - using this example, it is done via a form which exports the data via a report output as a .txt file.