Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: msaccess Output report to pdf then e-mail (Automation)

    experts, any body can help me regarding this problem, i am using access 2003, and a i m sorting reports, is there any chance we can produce reports from access 2003 output to pdf files then email to different accounts or single? please help...

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You can use this to create the PDF file:

    ReportToPDF

    and then Outlook automation to send it:

    Using Automation to Send a Microsoft Outlook Message
    Paul

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    You can also use a pdf print driver (Zeon Docucom, for instance) & print to the file, then attach the file to an email.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  4. #4
    Join Date
    Mar 2009
    Posts
    2

    I've got it!

    Dear Folks,
    It's easy, as soon as you know how to call it in your forms, It's very easy. Anybody can do this. cheersss!





    Quote Originally Posted by Jhun C
    experts, any body can help me regarding this problem, i am using access 2003, and a i m sorting reports, is there any chance we can produce reports from access 2003 output to pdf files then email to different accounts or single? please help...

  5. #5
    Join Date
    May 2006
    Posts
    386
    anyone can kindly advise how to automate this i.e. how to call from a Form and how to code the module or Form to pick a specific Report and email it to a specific employee whose details appear on the form.
    Emi-UK
    Love begets Love, Help Begets Help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •