Originally Posted by
ItsMe
Yes and thanks. I really think the Help for this command needs to really stress the fact you need to Open the report and select the report before the SendObject as shown in the example above and code below. Sometimes the SendObject will work without these commands but it isn't consistent and will drive you crazy. ;-)
Code:
DoCmd.OpenReport "strReport", acViewPreview, , strWhereDoCmd.SelectObject acReport, "strReport", False
DoCmd.SendObject acSendReport, strReport, acFormatPDF, strTo, strCc, strBcc, strSubject, strBody, True
DoCmd.Close acReport, "strReport"