Hello, i created this VBA script that attaches access report to the email as pdf file.
In this report i have two queries: one query pulls the report information, the second query is for the chart, that summarizes the report.
When i open this report in access it work fine, i can see all the information.
When this report get attached to the email, the chart doesn't get generated.
Here is the VBA:
1. First i am generating/saving this report on location on my C-drive.
DoCmd.OutputTo acOutputReport, "rpt_skills_training_this_year", acFormatPDF, strFilePath, False
2. I am attaching this report to email and emailing.
emaiSent = Email_Via_Outlook(strEmails, message![email_subject], message![email_message], False, strFilePath, strSignIn)
Ofcourse there is more code around this function, but these are the two lines that deal with pdf report file.
Any suggestion/solutions, why don't I see the chart on the report that is attached to the email. But I do get all the information when i am opening this report inside of Access?
Thank you in advance.