Can an Access 2010 report be emailed other than as a text file?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I've written the script to generate the email, attach the report (actually in the body of theemail) and send it to the correct people.
My issue is that I want to send only the relevant records from the report to each person. I've put the relevant person's email into the report (of a query) to make it easier. I want to email all the records with one email address to that email address and so on.
This would mean, for example, there are 6 records with [@email] in the email field of the report and 3 records with [@email]. I want the 6 records with [@email] to be emailed to [@email]and the 3 records with [@email] to be emailed to [@email].
The 2010 file was password protected and would not let me save as until the password was removed. I have now been able to remove the password, but still can't save it in2007 format.
I just installed Access Professional 2010 and the report works fine. So, no idea why it does not work in access 2010 non professional. Access 2010 is used by the Community Association and I am trying to help them get the Invoice Report to work correctly. In the report the $ amounts are showing as #Type or # error(only in 2010)
I know how to do the latter but if theres a better way in Access 2007 I would like to know.
What if I want to automate a report that uses a parameter query? Is there a way to do that? The report doesn't seem to have the parameter properties.
Background: I have one query that opens from a custom ribbon. The users enter the name of the person for which they want the report. Yesterday the boss told me I needed to have an individual report for all vendors that looks the same and can be emailed automatically.
Rather than copy and paste 24 reports and 24 queries. I was hoping that I could just associate thereport with the person it's being emailed to and iterate through the names for the report.
I currently do a lot of manual work in excel populatinginformation in each field.
I have attached the report as well as a dummy text file.
The Header still works OK if you run the database in Access 2003 (other PCs in our school are still using it), but when I use Access 2010, the report header is blank, both on screen and when printed!
all strings and variables are correct!
Here is the code that opens the report and applies the filter.
DoCmd.OpenReport strReportName, acViewPreview, , strSQL
the report opens fine, but no longer filters like it used to. (In my case I am filtering dates, using the # characters.)