Tags: access, body, copy, database, email, gurus, insert, message, microsoft, mysql, oracle, outlook, report, run, sql, suggest, thebody

Insert Report into Body of Email

On Database » Microsoft Access

3,971 words with 4 Comments; publish: Fri, 30 May 2008 17:28:00 GMT; (25062.50, « »)

I would like to run a report in Access and then copy the results into the

body of a new Outlook email message. Can any of you guru's suggest a

solution? Thanks in advance

All Comments

Leave a comment...

  • 4 Comments
    • Mark,

      You can try using a SendObject macro, and specify HTML for the Output

      Format. I am pretty sure that for recipients with most email clients

      will see the report in the email body when received.

      Steve Schapel, Microsoft Access MVP

      mark.ms-access.todaysummary.com.have_no_idea.com wrote:

      > I would like to run a report in Access and then copy the results into the

      > body of a new Outlook email message. Can any of you guru's suggest a

      > solution? Thanks in advance

      #1; Fri, 30 May 2008 17:29:00 GMT
    • Hi Steve,

      Thanks for your very quick reply. I tried the SendObject function -

      specifying HTML output - as you suggested and the result is that the report

      shows as an attachment to my Outlook email. I think I was not clear about

      the result I'm after... I would like the report copied into the body of the

      email - but not as an attachment - I'd like to be able to read the contents

      of the report right in the body of the email. Is there a way to create this

      result?

      - Mark

      "Steve Schapel" wrote:

      > Mark,

      > You can try using a SendObject macro, and specify HTML for the Output

      > Format. I am pretty sure that for recipients with most email clients

      > will see the report in the email body when received.

      > --

      > Steve Schapel, Microsoft Access MVP

      > mark.ms-access.todaysummary.com.have_no_idea.com wrote:

      >

      #2; Fri, 30 May 2008 17:30:00 GMT
    • Thanks for your help Steve! /// Mark

      "Steve Schapel" wrote:

      > Mark,

      > If you attach an html file to an email, a lot of email clients will show

      > it in the body of the email when received, assuming the recipient has

      > allowed html emails. That was my meaning. As far as I know, this is as

      > close as you will get to showing the report in the email. As far as I

      > know, the only way to get something coming through in the email body is

      > if it is either html or an image, and even then very dependent on the

      > settings of the recipient's software. Well, an Access report is

      > neither. It can be exported to an html file, or you could do a screen

      > shot of the report preview, save as an image file, and attach that...

      > but I don't know of a way to automate this.

      > --

      > Steve Schapel, Microsoft Access MVP

      > mark.ms-access.todaysummary.com.have_no_idea.com wrote:

      >

      #3; Fri, 30 May 2008 17:31:00 GMT
    • Mark,

      If you attach an html file to an email, a lot of email clients will show

      it in the body of the email when received, assuming the recipient has

      allowed html emails. That was my meaning. As far as I know, this is as

      close as you will get to showing the report in the email. As far as I

      know, the only way to get something coming through in the email body is

      if it is either html or an image, and even then very dependent on the

      settings of the recipient's software. Well, an Access report is

      neither. It can be exported to an html file, or you could do a screen

      shot of the report preview, save as an image file, and attach that...

      but I don't know of a way to automate this.

      Steve Schapel, Microsoft Access MVP

      mark.ms-access.todaysummary.com.have_no_idea.com wrote:

      > Hi Steve,

      > Thanks for your very quick reply. I tried the SendObject function -

      > specifying HTML output - as you suggested and the result is that the report

      > shows as an attachment to my Outlook email. I think I was not clear about

      > the result I'm after... I would like the report copied into the body of the

      > email - but not as an attachment - I'd like to be able to read the contents

      > of the report right in the body of the email. Is there a way to create this

      > result?

      > - Mark

      >

      #4; Fri, 30 May 2008 17:32:00 GMT