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've been trying to do this with a macro, but I think I'll need some VBA to get all functionality. Unfortunately its been several years since Ive written any code, and the knowledge seems to have left me. Im hoping one of you has done this and will be able to provide the code.
My needed process has several steps.
1 - save PDF to specified file path
2 - save as file name derived from the query that feeds the report
3 email the file to an address specified in the query that feeds the report.
3 name emailed file and populate subject line from fields in the same query.
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.
We need to run a query and then create a custom text file with the results.
We also want Access to add certain text to the text file before each data field or each new line of data.
Our thoughts were to run the query and report.
.and put the custom text into the report as custom field names or whatever.
1 - Is this the correct approach?
2 - If not how? (example/sample/tutorial if you can
3 - Can you "save" a report as a 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.