|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 25th, 2008, 04:50 AM
posted to microsoft.public.access,microsoft.public.access.forms
|
|||
|
|||
send email
How do you send email in the coding?
|
|
#2
February 25th, 2008, 05:14 AM
posted to microsoft.public.access,microsoft.public.access.forms
|
|||
|
|||
|
send email
-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" wrote in message ... How do you send email in the coding?
|
|
#3
February 25th, 2008, 05:29 AM
posted to microsoft.public.access,microsoft.public.access.forms
|
|||
|
|||
|
send email
How an access code in Module? Thanks.
"Jeanette Cunningham" wrote in message ... -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" wrote in message ... How do you send email in the coding?
|
|
#4
February 25th, 2008, 05:39 AM
posted to microsoft.public.access,microsoft.public.access.forms
|
|||
|
|||
|
send email
This is access code from a module that goes with a form.
Jeanette Cunningham " -Obama" wrote in message ... How an access code in Module? Thanks. "Jeanette Cunningham" wrote in message ... -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" wrote in message ... How do you send email in the coding?
|
|
#5
February 25th, 2008, 07:40 AM
posted to microsoft.public.access,microsoft.public.access.forms
|
|||
|
|||
|
send email
docmd.SendObject(acSendNoObject,,acFormatTXT,
",,,"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. "Jeanette Cunningham" wrote in message ... This is access code from a module that goes with a form. Jeanette Cunningham " -Obama" wrote in message ... How an access code in Module? Thanks. "Jeanette Cunningham" wrote in message ... -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" wrote in message ... How do you send email in the coding?
|
|
#6
February 25th, 2008, 04:29 PM
posted to microsoft.public.access.forms,microsoft.public.access
|
|||
|
|||
|
send email
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" wrote: docmd.SendObject(acSendNoObject,,acFormatTXT, ",,,"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. "Jeanette Cunningham" wrote in message ... This is access code from a module that goes with a form. Jeanette Cunningham " -Obama" wrote in message ... How an access code in Module? Thanks. "Jeanette Cunningham" wrote in message ... -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" wrote in message ... How do you send email in the coding?
|
|
#7
February 26th, 2008, 12:25 AM
posted to microsoft.public.access.forms,microsoft.public.access
|
|||
|
|||
|
send email
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. "Stockwell43" wrote in message ... 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" wrote: docmd.SendObject(acSendNoObject,,acFormatTXT, ",,,"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. "Jeanette Cunningham" wrote in message ... This is access code from a module that goes with a form. Jeanette Cunningham " -Obama" wrote in message ... How an access code in Module? Thanks. "Jeanette Cunningham" wrote in message ... -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" wrote in message ... How do you send email in the coding?
|
|
#8
February 26th, 2008, 01:24 AM
posted to microsoft.public.access.forms,microsoft.public.access
|
|||
|
|||
|
send email
It would help us if you posted the code you have already that checks for the
conditions. Jeanette Cunningham " -Obama" wrote in message ... 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. "Stockwell43" wrote in message ... 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" wrote: docmd.SendObject(acSendNoObject,,acFormatTXT, ",,,"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. "Jeanette Cunningham" wrote in message ... This is access code from a module that goes with a form. Jeanette Cunningham " -Obama" wrote in message ... How an access code in Module? Thanks. "Jeanette Cunningham" wrote in message ... -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" wrote in message ... How do you send email in the coding?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
