Welcome to SPN

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

Sign Up Now!

Automatically Email a report

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

  1. Gary Cottam

    Gary Cottam
    Expand Collapse
    Guest

    Hi,

    I'm trying to email a report from Access automatically, I want to be able
    to read the email address from a table as the recipient will be different for
    each report. I will also need to cc someone in who will also be different
    for each report.
     
  2. Loading...


  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Dundas used to have a freebie
    http://www.dundas.com/other/dundasmailer/index.aspx?Section=DundasMailer&Body=body.htm

    But it would seem they've removed it..

    http://www.microsoft.com/technet/archive/mail/ml302.mspx?mfr=true
    Gives you what you need though

    HTH

    Pieter

    "Gary Cottam" <Gary Cottam@discussions.microsoft.com> wrote in message
    news:F1819152-5BD9-426E-82F1-5F17E872CEE4@microsoft.com...
    > Hi,
    >
    > I'm trying to email a report from Access automatically, I want to be able
    > to read the email address from a table as the recipient will be different
    > for
    > each report. I will also need to cc someone in who will also be different
    > for each report.
    >
    >
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Dundas used to have a freebie
    http://www.dundas.com/other/dundasmailer/index.aspx?Section=DundasMailer&Body=body.htm

    But it would seem they've removed it..

    http://www.microsoft.com/technet/archive/mail/ml302.mspx?mfr=true
    Gives you what you need though

    HTH

    Pieter

    "Gary Cottam" <Gary Cottam@discussions.microsoft.com> wrote in message
    news:F1819152-5BD9-426E-82F1-5F17E872CEE4@microsoft.com...
    > Hi,
    >
    > I'm trying to email a report from Access automatically, I want to be able
    > to read the email address from a table as the recipient will be different
    > for
    > each report. I will also need to cc someone in who will also be different
    > for each report.
    >
    >
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Gary Cottam <Gary Cottam@discussions.microsoft.com> wrote:

    >Hi,
    >
    >I'm trying to email a report from Access automatically, I want to be able
    >to read the email address from a table as the recipient will be different for
    >each report. I will also need to cc someone in who will also be different
    >for each report.


    For a page on how to print a report for a single record and how to
    generate reports to attach to emails see the Emailing reports as
    attachments from Microsoft Access page at
    http://www.granite.ab.ca/access/email/reportsasattachments.htm

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page