Topics Search

Access 2010 PDF and Email a Report Using VBA Code

Access 2010 PDF and Email a Report Using VBA Code
Views: 283
I'm using Access 2010 and found the Send to Email as PDF command indispensible. However, I have a problem in that I've hidden the main ribbon from my users which means they can't actually click that button.

Can anyone tell me the VBA code that will let me PDF and email an indiviual report based on a given unique ID. I am happy for the user to add the email address, subject and message body and for them to click send
Sponsored Links:

Similar posts...

 

email a pdf report

email a pdf report Icon
Is there a way to email a pdf report in an MS Access subroutine?

I know that I can use SendObject to send a Snapshot View of a report. But who is at the other end to read it? The CIA could use snapshot format to send secret documents and no one would be able to break the code.

I need to send things as pdf's.

Again, I need to send a pdf from a MS Access program directly to an email attachment.
 

Convert to PDF

Convert to PDF Icon
A few quick questions in regards to converting a report to PDF.

At the moment the client uses the button on the Print Preview ribbon (Access 2010) to convert the report to a PDF file. Client is asking if it is possible to automatically select the "Standard Publishing" option as it seems to default to "Minimum Size" each time.

If I use VBA to open report as hidden, create email object and attach it as PDF does it automatically get converted to the highest quality
 

Send Report and Attachments in Email

Send Report and Attachments in Email Icon
User is looking at a job details. Job has pictures and PDF's as external files saved in the filesystem of the computer. User clicks Email Invoice. System attaches report as a PDFand opens Outlook Email message with email address, subject and body filled and the report PDF as an attachment

I can currently send a report as an attachment in an Outlook Email by using the "DoCmd.SendObject acSendReport" code.

That works nicely for me because it attaches the report I specify but has the limitation that I cannot attach any other objects.

I therefore came across the following code which allows me to add multiple attachments to an Outlook email message:

[CODE]

The problem with the above is that I cannot figure out how to attach a report of my choice. I don't know if there is a way to tell access to open a report and attach it as a PDF (in the above code).

Worst comes to worst, I'll try to figure out a way to save the report as a PDF (to the local filesystem) and then attach that as one of the attachments.
 

Email from

Email from Icon
I have created a button that looks up a query then emails the from data as a pdf report to the person listed in the code below. to instead use the email address in one of the fields in the form itself.

I can do this via VBA in word but do not know the code well enough in Access to perform the same job.
 

emailing in access 2010

emailing in access 2010 Icon
I'm currently using access 2010 to maintain a Model UN database, I need to send a mass confirmation email to head delegates of each team about their registration, and I need to attach a report in pdf, I have executed the macro action that converts the report in pdf and sends email to one head delegate but I want to automate the process, the email ID's of the heads are mentioned in the tblhead, and the report "paymentleaflet" has a query parameter of delegation ID(primary key of tblhead), how can I create a process that will, add the email address, from the query, select the report with the delegation id paramenter, attach it send it and move to the next record, and I dont have any expirence in visual basic
 

Displaying PDF files using VBA in access 2003

Displaying PDF files using VBA in access 2003 Icon
with code to open externally saved PDF files from a button on an access formn using VBA.

My pdfs are located in a folder on the c: drive

eg. c:/jobpacks/a/alfreton/yyy.pdf
/b/barnsley/xxx.pdf etc

All I want to do is open them and display them on the screen, I would then like to email them as an attachment
 

Report Caption

Report Caption Icon
I am using Access 2010. I would like to know if there is a way, when a report is opened, that the name of the report can be based off of a field within the report as well as a standard name.

For example, when I open the service report for customer Johnson, I would like when I export the report (via email or save as pdf) that the report name be Johnson Service Report, rather than Service Report. This name would also change when I open the service report for cusotmer Wilcox, the report name would then be Wilcox Service Report. Is this possible?

This way when I save the pdf to the digital file I do not have to rename it, as well as if I am sending the report via email the specific customer will be noted in the report name without having to change it manually.
 

Export to PDF and Email Report

Export to PDF and Email Report Icon
I have a report called [Banners Order Confirmation]. What I would like to do is with a click of a button, export the report as a pdf to a specified drive and folder and save it with a name by combining 2 fields from the report. Also, I would like to email this report to an email address which is also specified by a field on the report. I have tried different vb codes and have been very unsuccessful. Could you please help me or at least point me in some dirrection?
 

VBA code to send emails

VBA code to send emails Icon
I am running Access 2010 and I have created a IT helpdesk system. I want it to create an automatic email confirmation when we create helpdesk jobs.

I really need someone to help me with some code that will email the staff using Outlook 2010. I am not a expert on the code side of things.

I require the code assigned to the 'email button' and it will generate a email. Their email address will come from the Access database and in the body of the email there will job status, who it is assigned to etc. The email will then go to the persons email address.

I have attached a old copy of the database, I have saved it in 2000/03 incase people cant open it.
 

Printing report as PDF file in Access 2000

Printing report as PDF file in Access 2000 Icon
I would like to know if there is any why to print an access 2000 report as a PDF file so I can email it. I know I will need to loop through a list of contacts, read in their email address and then send the pdf file as an attachment and think I can do this. The problem I am having is getting access to create the PDF file.