Hi folks,
What would be the best way to submit a record from a form to a table and, at the same time, have that record emailed out via a report?
Thank you
Novice
Windows 7 64bit 
Access 2016
Hi folks,
What would be the best way to submit a record from a form to a table and, at the same time, have that record emailed out via a report?
Thank you
VIP
Windows 10 Access 2010 32bit
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "report name", , , "ID=" & Me!ID
DoCmd.SendObject acSendReport, "report name", , acFormatPDF, "email address here", , , , "subject text here", "message text here"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Access 2010 Send Outlook Email from Button Click - Failing to send email unless Outlook is open.
Email will no longer send. Run time error 2295. Unknown Recipients.
Posting Permissions
Reply With Quote