Automatic E-mail

[Greg2582]

I have a database used to answer question for different people. The question
originator submit a question using a form and it gets answered by someone
else. The originator has to check the database to see if and when their
question have been answered. IS there a way I can set up Access to send an
automatic e-mail when their question has been answered? If there a way this
can be performed, how can I do it?

 

[Ofer]

Use the
docmd.SendObject acSendNoObject,,,SendTo,CC,Bcc,Subject,MessageText

 

[Greg2582]

Thanks a lot, that really helped me a lot. Replies are getting sent
automatically. How can I add a the id number(key field) the database uses in
the MessageText?

 

[Ofer]

Where the ID comming from, is it a value from a form, or a value from a
dlookup.
To add any variable to the text you already have just add it with & symbol

docmd.SendObject acSendNoObject,,,SendTo,CC,Bcc,Subject, "Message Text
Inserted " & ID_Variable

You can also insert more text after the ID
docmd.SendObject acSendNoObject,,,SendTo,CC,Bcc,Subject, "Message Text
Inserted " & ID_Variable & " More Text"

 

[Greg2582]

The id is automatically generated when the form is used. I tried to use the &
symbol to add the id in the message text. No value is displayed at all.

 

[Ofer]

Post you code please
But first put a code break in the line where you send a message (press F9
while in code), then run it, when it stops check if the ID returns any value.