Welcome to SPN

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

Sign Up Now!

Email & Access

Discussion in 'Information Technology' started by GMA, Oct 29, 2005.

Tags:
  1. GMA

    GMA
    Expand Collapse
    Guest

    How can I send an email using Access? I tried the Office tab to change to a
    word or excel and it sets it up in unusable ways. I cannot copy and paste to
    these types of files either. Is there a way to add a tab to send the document
    as is via email, OLExpess, Hotmail, Comcast etc.
    Thanks
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Generally, in all the Office programs, the active document can be emailed by
    using:

    File ... SendTo

    In code, you can mimic this by using SendObject.

    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "GMA" <GMA@discussions.microsoft.com> wrote in message
    news:5756CB26-E8AF-4110-8C9E-076BC533CE74@microsoft.com...
    > How can I send an email using Access? I tried the Office tab to change to

    a
    > word or excel and it sets it up in unusable ways. I cannot copy and paste

    to
    > these types of files either. Is there a way to add a tab to send the

    document
    > as is via email, OLExpess, Hotmail, Comcast etc.
    > Thanks
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

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

    >How can I send an email using Access? I tried the Office tab to change to a
    >word or excel and it sets it up in unusable ways. I cannot copy and paste to
    >these types of files either. Is there a way to add a tab to send the document
    >as is via email, OLExpess, Hotmail, Comcast etc.


    It'll take a bit of digging to find an appropriate option.
    Microsoft Access Email FAQ
    http://www.granite.ab.ca/access/email.htm

    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.

    If you want to send multiple emails from a query or table you will
    need to use VBA code to run through a recordset either:
    1) concatenating the email addresses to a string along with a comma,
    sem-colon or other appropriate separator character, such as comma or
    semi-colon, and then send one email with
    all the bcc addresses;
    2) individually send the emails.

    Your method of sending emails may have some restrictions as to the
    number of email addresses in the bcc field or the length of data in
    that field.

    For sample recordset logic see
    http://www.granite.ab.ca/access/email/recordsetloop.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
     
  5. aziz elmousse

    aziz elmousse
    Expand Collapse
    Guest

    "Arvin Meyer [MVP]" <a@m.com> a écrit dans le message de
    news:%238CXlYH3FHA.700@TK2MSFTNGP15.phx.gbl...
    > Generally, in all the Office programs, the active document can be emailed

    by
    > using:
    >
    > File ... SendTo
    >
    > In code, you can mimic this by using SendObject.
    >
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "GMA" <GMA@discussions.microsoft.com> wrote in message
    > news:5756CB26-E8AF-4110-8C9E-076BC533CE74@microsoft.com...
    > > How can I send an email using Access? I tried the Office tab to change

    to
    > a
    > > word or excel and it sets it up in unusable ways. I cannot copy and

    paste
    > to
    > > these types of files either. Is there a way to add a tab to send the

    > document
    > > as is via email, OLExpess, Hotmail, Comcast etc.
    > > Thanks

    >
    >
     

Share This Page