nkrueger84
asked on
Setup Automated Report Emails from Access 2010
I am using the Access macro EMailDatabaseobject to create a PDF report that is emailed to X recipient. However, when I run the macro it simply opens and Outlook send email message with the PDF attached.
See here:
http://screencast.com/t/JwUzYQtKz
Which is nice, however, what I want to do is automatically send this email. I am setting up scheduled tasks to run these reports say once a week and they need to run when I am not around.
Everything I find is older vb scripts to automatically fill in lists of customers. I simply need to send it to X department heads on Y schedule.
The script I use to run it is as follows:
"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.E XE" /ro c:\RoutineReports\sp_repor ts.accdb /x EmailFutureEvents /nostartup
See here:
http://screencast.com/t/JwUzYQtKz
Which is nice, however, what I want to do is automatically send this email. I am setting up scheduled tasks to run these reports say once a week and they need to run when I am not around.
Everything I find is older vb scripts to automatically fill in lists of customers. I simply need to send it to X department heads on Y schedule.
The script I use to run it is as follows:
"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.E
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you looking for a solution within Access ? I remember you were interested to send attachments with change e-mails from SP. Is this question related?
ASKER
Thanks vasto but this is a different question. I would like to automatically send the emails from an Access macro if possible.
Daniel - that's the plan, except the script does not auto-send emails. That's what I am trying to figure out.
Daniel - that's the plan, except the script does not auto-send emails. That's what I am trying to figure out.
ASKER
wwwb0n3zcom I read up on blat and it sounds like it could work. But can you tell me how to use it within Access.
The Access example here does not really say how to use it to the non-programmer.
http://www.blat.net/examples/MSAccess_class.html
The Access example here does not really say how to use it to the non-programmer.
http://www.blat.net/examples/MSAccess_class.html
Yes, so if you are able to create a scheduled task, which running that script, it will send this email right?
So it will send automatically on set frequency.
See below example on how to accomplish this:
http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-run-process.html
Hope this helps,
Daniel
So it will send automatically on set frequency.
See below example on how to accomplish this:
http://rogersaccessblog.blogspot.com/2008/11/access-101-how-do-i-run-process.html
Hope this helps,
Daniel
nkrueger84 - what version of Access are you using?
Create a new scheduled task, and your script to it.
Hope this helps,
Daniel