Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Private Sub Command28_Click() DoCmd.RunCommand acCmdSaveRecord Forms!InvoiceNoEmail.SetFocus Dim oApp As Object Dim oEmail As Outlook.MailItem Dim fileName As String Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("SELECT [Account], [InvoiceNum], [EmailAddress], [Company], [Printed] FROM [ContactTotalsNoEmail] WHERE (((Contracts.SelectedPrint)=True)) ORDER BY [Account];", dbOpenDynaset) Do While Not rst.EOF strRptFilter = "[InvoiceNum] = " & Chr(34) & rst![InvoiceNum] & Chr(34) DoCmd.PrintOut fileName = "C:\Scripts\NoEmail" & "\" & rst![Account] & " - " & rst![InvoiceNum] & ".pdf" DoCmd.OutputTo acOutputReport, "InvTotalNoEmail", acFormatPDF, fileName rst.Edit rst![Printed] = "Yes" rst.Update DoEvents rst.MoveNext Loop rst.Close Set rst = Nothing Forms!InvoiceNoEmail.Requery End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.