Welcome to SPN

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

Sign Up Now!

Records..email

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

Tags:
  1. teelee

    teelee
    Expand Collapse
    Guest

    Does anyone kow if you can email records after they are updated?
     
  2. Rick B

    Rick B
    Expand Collapse
    Guest

    You can email a report showing the data in a record. Or you could insert
    the value from some of the fields in a record using code.

    --
    Rick B



    "teelee" <teelee@discussions.microsoft.com> wrote in message
    news:657AAAE9-39DC-4D5C-9653-DD54C9654A27@microsoft.com...
    > Does anyone kow if you can email records after they are updated?
     
  3. teelee

    teelee
    Expand Collapse
    Guest

    Is there no way to email the data that you have entered into a record?

    Thanks

    "Rick B" wrote:

    > You can email a report showing the data in a record. Or you could insert
    > the value from some of the fields in a record using code.
    >
    > --
    > Rick B
    >
    >
    >
    > "teelee" <teelee@discussions.microsoft.com> wrote in message
    > news:657AAAE9-39DC-4D5C-9653-DD54C9654A27@microsoft.com...
    > > Does anyone kow if you can email records after they are updated?

    >
    >
    >
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    Yes. When you construct an email in code, you can pull field data into the
    body of the email.

    Do a search on constructing an email through code and you can find many
    examples of how to include field data in the message body.

    --
    Rick B



    "teelee" <teelee@discussions.microsoft.com> wrote in message
    news:B94B21CE-F3CF-4279-A14C-5E30AD7ADF4D@microsoft.com...
    > Is there no way to email the data that you have entered into a record?
    >
    > Thanks
    >
    > "Rick B" wrote:
    >
    >> You can email a report showing the data in a record. Or you could insert
    >> the value from some of the fields in a record using code.
    >>
    >> --
    >> Rick B
    >>
    >>
    >>
    >> "teelee" <teelee@discussions.microsoft.com> wrote in message
    >> news:657AAAE9-39DC-4D5C-9653-DD54C9654A27@microsoft.com...
    >> > Does anyone kow if you can email records after they are updated?

    >>
    >>
    >>
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    teelee <teelee@discussions.microsoft.com> wrote:

    >Does anyone kow if you can email records after they are updated?


    To create a formatted document to send as an email you will need to
    use VBA code to create a largish string. This string will then be
    passed to the SendObject command or other method as the body of the
    email. For more details including sample air code see my Tips page
    on this topic at http://www.granite.ab.ca/access/email/formatted.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
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    if they're updated in the table *no* (access have no triggers)
    through a form *yes* (use mail functionallity in the Forms AfterUpdate
    event)

    hth

    Pieter

    "teelee" <teelee@discussions.microsoft.com> wrote in message
    news:657AAAE9-39DC-4D5C-9653-DD54C9654A27@microsoft.com...
    > Does anyone kow if you can email records after they are updated?
     

Share This Page