WhtChoklat
Technical User
I am trying to ouput to a file then email an attachment of the file and a link to the webpage it will be on. I am receiving errors when I try to output the file, the email is working good. Here is my code, could someone please help?
Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String
Dim outFile, filename, date1, path, ext As String
date1 = Date
path = pathname
ext = ".html"
filename = "Minutes" + date1
outFile = path + filename + ext
DoCmd.OutputTo acOutputReport, "Minutes - Report", acFormatHTML, outFile, False
txtTO = "riche@pjm.com"
txtCC = ""
txtBCC = ""
txtSubject = "Test18"
txtMessage = ""
DoCmd.SendObject acSendReport, "Minutes - Report", acFormatHTML, txtTO, txtCC, txtBCC, txtSubject, txtMessage, False
Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String
Dim outFile, filename, date1, path, ext As String
date1 = Date
path = pathname
ext = ".html"
filename = "Minutes" + date1
outFile = path + filename + ext
DoCmd.OutputTo acOutputReport, "Minutes - Report", acFormatHTML, outFile, False
txtTO = "riche@pjm.com"
txtCC = ""
txtBCC = ""
txtSubject = "Test18"
txtMessage = ""
DoCmd.SendObject acSendReport, "Minutes - Report", acFormatHTML, txtTO, txtCC, txtBCC, txtSubject, txtMessage, False