send email

[-Obama]

How do you send email in the coding?

 

[Jeanette Cunningham]

-Obama,
here is an example that emails an error log back to me

DoCmd.SendObject acReport, "rptErrorLog", "SnapshotFormat(*.snp)",
"MyEmailAddress", , , "Log from MyApp", "Log sent on " & Date, False

Jeanette Cunningham

 

[-Obama]

How an access code in Module? Thanks.

-Obama,
here is an example that emails an error log back to me

DoCmd.SendObject acReport, "rptErrorLog", "SnapshotFormat(*.snp)",
"MyEmailAddress", , , "Log from MyApp", "Log sent on " & Date, False

Jeanette Cunningham

 

[Jeanette Cunningham]

This is access code from a module that goes with a form.

Jeanette Cunningham

 

[-Obama]

docmd.SendObject(acSendNoObject,,acFormatTXT,
"(e-mail address removed)",,,"testing","testing"," "," ")

I tried to run the above code in debug window window. It gives me an error:

Compiled Error:

Expected:=


Can you please help? Thanks.

 

[Stockwell43]

Hi Obama,

Is there a reason why you need to code this? If all your looking to do is
pull up a blank email when you click a button on your form, just use a macro.
It will take you a few minutes to create with no errors because Access is
doing all the coding. If fact after you complete and install it to your
button, you can convert it to VBA Code to see what it looks(but do it on a
test or copy database).

 

[-Obama]

I want to create and send email based on certain condition met. Therefore I
need to use access code. I am not sure if your method works for my
situation. Please help. Thanks.

 

[Jeanette Cunningham]

It would help us if you posted the code you have already that checks for the
conditions.

Jeanette Cunningham