Trying to create 3 e-mail command buttons in my form :(

[manito2000]

Hello...

I have a DB where I'd like to include on the form 3 e-mail buttons...3 different e-mail recipients.

I'd like to be able to press the button and have my Outlook e-mail the person (assigned to each button) and pull the record number field and the due date field and put it in the Outlook subject line...

Is this possible? Or am I dreaming?

Manito2000

 

[pbaldy]

Pretty easy actually. Look at SendObject in VBA help. To get a value from the form, you can use:

Me.ControlName

as you build the subject or body.