Results 1 to 3 of 3
  1. #1
    crxftw is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    30

    Converting report to PDF and attach it to email

    Hello, I've been trying to find solutions how I am able to convert currently opened report to PDF and attach it to outlook e-mail. I am using Access2k10 and I tried EmailDatabaseObject macro function and SendObject through VBA but these have some flaws that I can't have. I need message body to be either from template file (message text is different which depends on area to where email will be sent). Both that I mentioned don't let me format body text in html which i need as I must get logo to email together with long text.

    Any suggestions how it's the easiest way to do these two (convert to pdf and attach to outlook) operations with one button click?



    Regards

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377

  3. #3
    lilysia is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Location
    USA
    Posts
    2
    I am not so clear what you mean, I guess you want to attach a file to e-Mail for distribution, but the file is not suitable for attaching onto outlook e-mail, so you want to attach it as pdf file. And you only need a portion of the file to be attached as pdf.

    So my suggestion is to use a screen capture program like “Snagit” to capture the desire part image, then convert image to pdf in Photoshop or other pdf creation software.

    Or, if you can copy the part you want, you can paste it into Microsoft word 2007 or 2010, since there is already a “save as pdf” option for you to export to pdf. Hope it can help you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-23-2011, 08:07 AM
  2. Replies: 4
    Last Post: 04-13-2011, 10:11 AM
  3. Email from report to Email body
    By Ehmke66 in forum Programming
    Replies: 4
    Last Post: 01-03-2011, 01:06 PM
  4. Can't attach to email
    By newtoAccess in forum Access
    Replies: 10
    Last Post: 12-03-2010, 02:10 PM
  5. Attach Email to Form
    By Huddle in forum Access
    Replies: 2
    Last Post: 07-22-2010, 12:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums