 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / April 2008Email based on criteria
I know how to do this in excel however I am new to access. I have a form that is to be updated in three parts. If the form is not updated after a certain period then an exception is generated identifying the party that has not completed their task. My question is this a report function or another method to accomplish this? The intent is that a button is on the switchboard that generates this liost that is to be emailed. Thanks Robert Hi Robert, You can use SendObject, which will use your default eMail program 'SendObject '[objecttype] '[, objectname] '[, outputformat] '[, to] '[, cc] '[, bcc] '[, subject] '[, messagetext] '[, editmessage] '[, templatefile] It would be good to make a report and send that ... but if what you are sending is just a list, perhaps a query would work best ... Warm Regards, Crystal * (: have an awesome day :) * > I know how to do this in excel however I am new to access. > I have a form that is to be updated in three parts. If the form is not [quoted text clipped - 7 lines] > Thanks > Robert |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.