Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Email A Report Question

Discussion in 'Information Technology' started by StuJol, Jul 28, 2006.

  1. StuJol

    StuJol
    Expand Collapse
    Guest

    I have designed an advert using a report in Access2203. The report contains
    grahics and text. I now want to email this report to some of my customers but
    i am struggling doing so. Im using the docmd.sendobject which works as it
    should but its creating an attachment for my report whereas i would prefare
    to use my report as the main email text, if you know what i mean? i dont want
    an attachment.

    Any help would be much appreciated.
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    You can write the data from a recordset out to the body of the report using
    sendobject. Base your recordset on the query which is the recordsource for
    the report. The syntax for the SendObject statement would then be something
    like:

    DoCmd.SendObject acSendNoObject, , , strTo, , , strSubject, strMessage
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access


    "StuJol" <StuJol@discussions.microsoft.com> wrote in message
    news:272CAA0E-ACA0-4864-90F3-D1FD79EDF3F2@microsoft.com...
    > I have designed an advert using a report in Access2203. The report

    contains
    > grahics and text. I now want to email this report to some of my customers

    but
    > i am struggling doing so. Im using the docmd.sendobject which works as it
    > should but its creating an attachment for my report whereas i would

    prefare
    > to use my report as the main email text, if you know what i mean? i dont

    want
    > an attachment.
    >
    > Any help would be much appreciated.
     
  4. StuJol

    StuJol
    Expand Collapse
    Guest

    Thanks for info, i have now done it this way as it seems easyier. Do you know
    how i can add a graphic to the email text using the docmd.sendobject method.
    I want to insert a graphic from a location on my harddrive into the text of
    the email, just like a header. Any ideas

    "Arvin Meyer [MVP]" wrote:

    > You can write the data from a recordset out to the body of the report using
    > sendobject. Base your recordset on the query which is the recordsource for
    > the report. The syntax for the SendObject statement would then be something
    > like:
    >
    > DoCmd.SendObject acSendNoObject, , , strTo, , , strSubject, strMessage
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    >
    > "StuJol" <StuJol@discussions.microsoft.com> wrote in message
    > news:272CAA0E-ACA0-4864-90F3-D1FD79EDF3F2@microsoft.com...
    > > I have designed an advert using a report in Access2203. The report

    > contains
    > > grahics and text. I now want to email this report to some of my customers

    > but
    > > i am struggling doing so. Im using the docmd.sendobject which works as it
    > > should but its creating an attachment for my report whereas i would

    > prefare
    > > to use my report as the main email text, if you know what i mean? i dont

    > want
    > > an attachment.
    > >
    > > Any help would be much appreciated.

    >
    >
    >
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Email graphics are a function of the UI of each machine. Without html or
    rtf, there's no way to embed a graphic. Since you cannot control that from
    VBA (without using Outlook automation) or in a system like Outlook Express,
    I don't think you can do that.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "StuJol" <StuJol@discussions.microsoft.com> wrote in message
    news:52FAACDE-E581-42F7-B809-19DFAE139FC3@microsoft.com...
    > Thanks for info, i have now done it this way as it seems easyier. Do you

    know
    > how i can add a graphic to the email text using the docmd.sendobject

    method.
    > I want to insert a graphic from a location on my harddrive into the text

    of
    > the email, just like a header. Any ideas
    >
    > "Arvin Meyer [MVP]" wrote:
    >
    > > You can write the data from a recordset out to the body of the report

    using
    > > sendobject. Base your recordset on the query which is the recordsource

    for
    > > the report. The syntax for the SendObject statement would then be

    something
    > > like:
    > >
    > > DoCmd.SendObject acSendNoObject, , , strTo, , , strSubject, strMessage
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > >
    > > "StuJol" <StuJol@discussions.microsoft.com> wrote in message
    > > news:272CAA0E-ACA0-4864-90F3-D1FD79EDF3F2@microsoft.com...
    > > > I have designed an advert using a report in Access2203. The report

    > > contains
    > > > grahics and text. I now want to email this report to some of my

    customers
    > > but
    > > > i am struggling doing so. Im using the docmd.sendobject which works as

    it
    > > > should but its creating an attachment for my report whereas i would

    > > prefare
    > > > to use my report as the main email text, if you know what i mean? i

    dont
    > > want
    > > > an attachment.
    > > >
    > > > Any help would be much appreciated.

    > >
    > >
    > >
     

Share This Page