Topics Search

Can an Access 2010 report be emailed other than as a text file?

Can an Access 2010 report be emailed other than as a text file?
Views: 4
I have been away from working with Access for a long time. I have Access 2010 and have created a report that I need to email to a business. I can only find how to email the report as a text file which is not acceptable for my use. Is there a way of doing this?
Sponsored Links:

More topics

 

Can an Access 2010 report be emailed other than as a text file?

Preview
I have been away from working with Access for a long time. I have Access 2010 and have created a report that I need to email to a business. I can only find how to email the report as a text file which is not acceptable for my use. Is there a way of doing this?
 

Filter a Report Based on an Attribute a to be Emailed VBA

Preview
I'm using Windows 7, Access 2007, Outlook 2010

Background:
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.

Issue:
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.

Example:
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].
 

Access 2007 email report and Excel sheet

Preview
I have a report in Access 2007 that needs to be emailed alongwith a spreadsheet. Is there a simple way to do this in Access 2007 or am I up for creating the report in PDF format using Stephan Lebans code and other code to attach that PDF file as well as the Excel file as attachments?

I know how to do the latter but if theres a better way in Access 2007 I would like to know.
 

Save a access 2010 db as 2007 db

Preview
I have a db in access 2010 (used to be 2007). The invoice report works OK if opened in 2007, but not in 2010.

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)
 

Import Text File In Access 2010

Preview
Access 2010 include a feature of importing raw text data in to tables, this could be very helpful when you are just writing down numbers, text, etc in text editors because they are easy and simple to use. This post will elaborate how to import and organize Text document in to Access 2010.
 

Save, rename and email report

Preview
I'm in Access 2007 and stuck.

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.
 

Report with Parameter Query

Preview
I've seen some examples of where people automate parameters in a query IE:

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.
 

Automate report on ACCESS

Preview
I have a report Template in PDF that I use to manually populate information I get from a Data warehouse(See Attached). What I want to do is to create an Automated report in Access that can Help me Import a Text File into Access and then Get an Output Report in PDF format that will Look Exactly like the report attached.

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.
 

Export Table To Plain Text In Access 2010

Preview
RDBMS (Relational Database Management System) are not abound, therefore, when sharing Access 2010 content with someone, you need to confirm if it is installed on the other end. For covering this up, Access 2010 provides an easy way to export database table into plain text file. Thus, you can easily exchange and share a text file which doesn’t require any specific compiler/encoder to open it.
 

How to export/save a Query or Report as Text File?

Preview
With Access 2007 on PC XP Pro.

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.

The question:

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?