Email a record from Access

[mike1975]

I am building an application that logs calls. I have a form where individual calls are logged as and when they are taken. I need to somehow get the application to e-mail the person who has logged the call with all the details that have been logged. Ideally I would like this to run off a button so that when the log has been completed the button is pressed and the record that is being diplayed on the screen is sent! I am fairly new user to Access and not very familiar with the wonders of VB.

Mike

 

[rry2k]

Mike,

This can be done with a button. Go to help and type SendObject Method for the exact syntax. It will be something like DoCmd.SendObject acSendForm,, etc. etc.
If you need further help feel free to email me. We were all new once.

Russ

 

[mike1975]

Russ,

Thanks for that - I am building the code now! It has got me thinking whether or not I can get the code to pick the email address of the recipient from a field on a table?

Hope you're still about?

Mike

 

[rry2k]

Mike,
Glad to help. You might want to put a field on the form which asks for the users email address then put that into a variable and build it into the sendObject string.

Russ