Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    send PDF as email attachment (2003)

    Hi,

    I find "A2000ReportToPDF" can convert reports to PDF documents. So is any way we can use "sendobject" or some other tools to automaticly convert reports to PDF as email attachement. I can do only with Snapshot file, but PDF is working for everybody.

    Any question, is any way better than "A2000ReportToPDF" to convert reports to PDF documents?

    Thanks

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: send PDF as email attachment (2003)

    There is no inbuilt support for pdf in Access ( I think this is changing with the next version.)

    SendObject can only send database objects such as reports using the inbuilt formats.

    So to send a pdf you need to automate the creation of the pdf file, which then becomes an external file rather than a database object. SendObject does not support external attachments.

    However Outlook Automation does support external attachments, so if you use Outlook as you mail program you can probably do it that way, but it would take a lot more code.

    If you search through the posts you will find some examples of code.

    I am not familiar with A2000ReportToPDF. I presume it is a pdf cretor. Does it allow for automatic saving of the pdf file?
    Regards
    John



  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: send PDF as email attachment (2003)

    Thanks.

    Can you explain more detail or show me some example? I did search on the web but I still don't really know how it's work and it solve my problem.

    Thank you so much

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: send PDF as email attachment (2003)

    See the thread starting at <post:=383,300>post 383,300</post:> for an example of how to create an e-mail and add an attachment.

Posting Permissions

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