try this macro, change the path to the correct report and change the emailaddress to an existing one.
You can change the report format to any other report type in this case it is pdf format
Good Luck!
Christenhusz
' macro to run an Impromptu report
' save the reports in pdf format with the date appended to the report name
' create an email in Outlook with the pdf attached
Dim strToday As String
Dim strReportName1 As String
Dim strCatalogName1 As String
Dim strUserClass As String
Dim strFileName1 As String
Dim strTo1 As String
msgbox "The pdf report has been generated!"
strSubject = "All Country Sales Report"
strBody = "Please find attached your pdf report. If you have any questions, please do not hesitate to contact me." & Chr(13) & Chr(13) & "John Doe" & Chr(13) & "Impromptu Report Administrator" & Chr(13) & "1-800-123-4567" & Chr(13) & Chr(13)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.