var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Auto Email
I have an email address in my table. How do I email a report associated with that record to the corresponding email address in the table.
docmd.SendObject acSendReport, "ReportNameHere",,"Email@Address.com"
Use code similar to this. This will get theemail address and open outlook so that you can add a message etc. If you change True to false it will automatically send the email.
Dim email_subject As String
Dim email_address As String
dim report_name as string
email_address= Use DLookup to obtain the mail address
report_name = "Enter name of report"
email_subject = "Enter email subject"
DoCmd.SendObject acReport, report_name, "SnapshotFormat(*.snp)", email_address, "", "", email_subject, "", True, ""
Note report_name and email_subject each must be enclosed by double quotes.
Do a Google search on vbSendMail. It is by far the easiest and most complete email solution out there.