Results 1 to 4 of 4

Email function to place an report as a screenshot in the email body?

  1. #1
    djspod is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Posts
    164

    Email function to place an report as a screenshot in the email body?

    Hi ,

    Is it possible to set up that a report goes straight into the email body instead of the attachment (Pdf, word etc)

    The bosses use their phones to view the morning report and they are not too IT savvy on opening attachments.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,410
    The report would have to be converted to a jpg or bmp or tiff file. AFAIK, Access does not have intrinsic capability.

    Could concatenate data into email body.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    djspod is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Posts
    164
    Thanks for June7

    Ref: Could concatenate data into email body?

    That sounds a good idea, do u know of any help guides to assist myself?

    Thanks for your help

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,410
    No guides that I know of. It is a common topic in forum. Start with https://www.accessforums.net/program...ook-21903.html

    The referenced threads have examples of VBA code that opens Outlook objects. The SendObject method could also be used to send email with concatenated data in body.

    Search web.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Send Report as body of email
    By chris.williams in forum Reports
    Replies: 3
    Last Post: 09-15-2012, 09:43 AM
  2. Email report as body of email (RTF)
    By TheDeceived in forum Programming
    Replies: 4
    Last Post: 07-23-2012, 06:39 AM
  3. Email report as body of email
    By chrish20202 in forum Programming
    Replies: 6
    Last Post: 01-15-2012, 07:23 PM
  4. Replies: 1
    Last Post: 05-23-2011, 08:07 AM
  5. Email from report to Email body
    By Ehmke66 in forum Programming
    Replies: 4
    Last Post: 01-03-2011, 01:06 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
  •  
Tech Forums: Microsoft Office Forums