[AccessD] Access Report to PDF File to EMAIL Attachement

Using PowerPDF I have this code behind a button to "print" the report. Maybe
someone else can share the code to save the file and attach it to an email
automatically.
Jim Hale

Private Sub CmdPrintPDF_Click()
    Dim lngRetval As Long
On Error GoTo Err_CmdPrintPDF_Click
    lngRetval = MsgBox( _
        "Do you want to print the report?", _
        vbYesNo + vbQuestion + vbSystemModal + vbDefaultButton1, _
        "Daily Sales Report")

    Select Case lngRetval
    
        Case vbYes
            Application.ActivePrinter = "PowerPDF Printer on VSP1:"
            ActiveWorkbook.PrintOut Copies:=1, ActivePrinter:= _
            "PowerPDF Printer on VSP1:"
        Case vbNo
    End Select
The_End:
    
Exit Sub

Err_CmdPrintPDF_Click:
     MsgBox "The following error occured: " & Error$
    Resume The_End

End Sub

-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com]
Sent: Wednesday, January 04, 2006 10:55 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Report to PDF File to EMAIL Attachement


Thanks for your response Susan.
   
  Manual Intervention:
  I have one procedure that opens the report and then the user saves the
report as a PDF through the FILE==>PRINT option. Then they manually attach
the file to an email. 
   
  dll Files: 
  The other procedure that was given to me requires two dll files to work in
concert with some code, but we are having problems getting the dll files to
work on every machine. 
   
  Thanks again for taking the time.

Susan Harkins <harkinsss at bellsouth.net> wrote:
  What do you mean by "manual intervention or use of additional dll files?" 

You can do this with a little code, but there's no built-in feature for
doing it. 

Susan H. 


Is there a process by which an Access report can be saved to a pdf file then
attached to an email without any manaul intervention or use of additional
dll files?


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
  




May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 





		
---------------------------------
 Yahoo! DSL Something to write home about. Just $16.99/mo. or less
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.