send email

J

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
 
O

-Obama

How an access code in Module? Thanks.


Jeanette Cunningham said:
-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
Click to expand...
 
J

Jeanette Cunningham

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

Jeanette Cunningham
 
O

-Obama

docmd.SendObject(acSendNoObject,,acFormatTXT,
"[email protected]",,,"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.
 
S

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).
 
O

-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.
 
J

Jeanette Cunningham

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

Jeanette Cunningham
 
Top