Automatic Mail Tamplate

[yoavchen]

i would like to send mails with a tamplate in the subgect and the free text body.

i have this code that allow me to open the mail and fill the "to" with two email adresses.

Private Sub cmdEmail_Click()
On Error GoTo Err_cmdEmail_Click

Me.cmdEmail.HyperlinkAddress = "mailto:" & Me.ManagerEmail & ";" & Me.AboveManegerEmail

Exit_cmdEmail_Click:
Exit Sub

Err_cmdEmail_Click:
MsgBox Err.Description
Resume Exit_cmdEmail_Click

End Sub


i also would like to know if there is a way when i click on the btn of opening the mail with the tamplte, that an automatic mail will be sent to the addressees.

thanks

 

[reclusivemonkey]

Try the DoCmd.SendObject method. Use the Access help for more information; this method will send the email without any user interaction, or at least it does with GroupWise on my system, so if you are using Outlook, it should work as well.