I am using vba code to have Access 2016 send emails via Outlook 2016 based on query results. The code works perfectly in its current state. Basically, this is designed to automate a follow up process 19 days after an estimate is provided to a client.However, in the same table that the query pulls from exists an open field for each record titled FUPSentDate. I would like this process to go back to that field for each client it sends an email to and insert the current date in that client's record as evidence that the email was sent (also because that field will become a 2nd and integral part of the query criteria in that I only want to send emails to those that have not already been sent one).Can you help?
MS Access – VBA – Rename attachment in SendObect Method. August 16, 2012. This is all find an dandy, but there is one flaw, it uses the name of your MS Access report: “rptSalesForecast” or “rptSalesByRegion” access as the attachment name. Just saved me having to write a whole custom piece of code to send emails via Outlook. This post will provide you with the needed code to email pdf's from Access. Skip to content. CONTACT US TODAY (773) 809 5456 [email protected]. Email reports from Access as PDF attachments in Outlook. Juan Soto is a Senior Access Developer at IT Impact Inc. And a Microsoft Access MVP. He specializes in Access with SQL Server databases.
I am trying to automate sending daily reports to a select list of internal employees, and Access 2007 is only letting me send one at a time, not multiple reports in a single email.
Not only do I have this problem, but, each time I try to send one usingthe macro function (this is one report for one email) MS Outlook asks me to accept/deny this priviledge. How do I get around this, so that I can automate the sending of multiple reports, and override the security of MS Outlook that forces me to accept/deny sending the email? My boss would like me to send out the reports on his behalf as if it is from his email box? Can this be done?
Not only do I have this problem, but, each time I try to send one usingthe macro function (this is one report for one email) MS Outlook asks me to accept/deny this priviledge. How do I get around this, so that I can automate the sending of multiple reports, and override the security of MS Outlook that forces me to accept/deny sending the email? My boss would like me to send out the reports on his behalf as if it is from his email box? Can this be done?