Sendobject

[access_novice1234567]

I have a form which users use to record concerns. The form automatically generates a concern i.d. number as a field on the form. When the user enters the project name I have a lookup field which displays the name of the project manager. I want to send an automatic email to the project manager to alert him to the concern, and to include the concern i.d. number.

So, a sendobject command which gets the address from a field on the form, and also includes in the email text a field from the form.

Can anyone help?

As my name says, I am a real novice, so thanks in advance for your patience.

 

[ted.martin]

Rather than the SendObject method, I prefer to use the Outlook Object Library. The answer is here although the code is far more than you need so you will need to pick out the appropriate part.
http://www.access-programmers.co.uk/forums/showthread.php?t=141517&highlight=e-mail