Welcome to SPN

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

Sign Up Now!

Send eMail to several addresses at once

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

  1. Ig

    Ig
    Expand Collapse
    Guest

    Hi, I need to send email from access to several clients at once.

    Private Sub cmdSend_Click()
    Dim Item As Variant
    For Each Item In Me!lstNames.ItemsSelected
    DoCmd.SendObject , , , Me!lstNames.Column(1, Item), , ,
    Me!lstSubjects.Column(1), "Dear " &
    Me!lstNames.Column(0, Item) & "," &
    vbCrLf & vbCrLf & _
    Me!txtEMailText, False
    Next Item
    End Sub

    For every email address I get screen with "Outlook Express" title that says:
    "A program is attempting to send
    the following e-mail message on your behalf" and shows fields "To:",
    "Subject:" and asks "Would you like to
    send the message?" so you need for each email to confirm.
    My question: how to avoid this screen? By the way it never shows email
    address in this "To:" field but deliveres email without problem.
    Thank you.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Why This Sikh Cartoonist Is Sending A Postcard To Trump Every Day Breaking News Mar 23, 2016
    UK Statue of turbaned Sikh fighter pilot unveiled in Gravesend Breaking News Nov 29, 2014
    Leisure Appropriate to send flowers to a friend's ill Mother in India? Business, Lifestyle & Leisure Jun 6, 2013
    USA Preet Bharara Sends a Message to Wall Street about Insider Trading Breaking News May 18, 2011
    USA U.S. Sends Warning to People Named in Cable Leaks Breaking News Jan 7, 2011

  3. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear Igor:

    Yes! I remember this problem. There's a free third party solution, as I
    recall. It causes this message to be answered automatically.

    I'll ask around and try to find the details of what this is and where to
    find it. I hope I can get back to you tonight with what it was. I thought
    this might be enough where you might find it yourself.

    Tom Ellison


    "Ig" <Igor.Pipkin@sasktel.net> wrote in message
    news:12688495qelr14d@corp.supernews.com...
    > Hi, I need to send email from access to several clients at once.
    >
    > Private Sub cmdSend_Click()
    > Dim Item As Variant
    > For Each Item In Me!lstNames.ItemsSelected
    > DoCmd.SendObject , , , Me!lstNames.Column(1, Item), , ,
    > Me!lstSubjects.Column(1), "Dear " &
    > Me!lstNames.Column(0, Item) & ","
    > & vbCrLf & vbCrLf & _
    > Me!txtEMailText, False
    > Next Item
    > End Sub
    >
    > For every email address I get screen with "Outlook Express" title that
    > says: "A program is attempting to send
    > the following e-mail message on your behalf" and shows fields "To:",
    > "Subject:" and asks "Would you like to
    > send the message?" so you need for each email to confirm.
    > My question: how to avoid this screen? By the way it never shows email
    > address in this "To:" field but deliveres email without problem.
    > Thank you.
    >
     
  4. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    You might be thinking of the free Express ClickYes
    http://www.express-soft.com/mailmate/clickyes.html (although there are
    others as well)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    news:ejeK5cZdGHA.3348@TK2MSFTNGP03.phx.gbl...
    > Dear Igor:
    >
    > Yes! I remember this problem. There's a free third party solution, as I
    > recall. It causes this message to be answered automatically.
    >
    > I'll ask around and try to find the details of what this is and where to
    > find it. I hope I can get back to you tonight with what it was. I
    > thought this might be enough where you might find it yourself.
    >
    > Tom Ellison
    >
    >
    > "Ig" <Igor.Pipkin@sasktel.net> wrote in message
    > news:12688495qelr14d@corp.supernews.com...
    >> Hi, I need to send email from access to several clients at once.
    >>
    >> Private Sub cmdSend_Click()
    >> Dim Item As Variant
    >> For Each Item In Me!lstNames.ItemsSelected
    >> DoCmd.SendObject , , , Me!lstNames.Column(1, Item), , ,
    >> Me!lstSubjects.Column(1), "Dear " &
    >> Me!lstNames.Column(0, Item) & ","
    >> & vbCrLf & vbCrLf & _
    >> Me!txtEMailText, False
    >> Next Item
    >> End Sub
    >>
    >> For every email address I get screen with "Outlook Express" title that
    >> says: "A program is attempting to send
    >> the following e-mail message on your behalf" and shows fields "To:",
    >> "Subject:" and asks "Would you like to
    >> send the message?" so you need for each email to confirm.
    >> My question: how to avoid this screen? By the way it never shows email
    >> address in this "To:" field but deliveres email without problem.
    >> Thank you.
    >>

    >
    >
     
  5. Tom Ellison

    Tom Ellison
    Expand Collapse
    Guest

    Dear Douglas:

    Yes. That sounds right. It solved just this problem for me.

    Tom Ellison


    "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:Oz70OpadGHA.1264@TK2MSFTNGP05.phx.gbl...
    > You might be thinking of the free Express ClickYes
    > http://www.express-soft.com/mailmate/clickyes.html (although there are
    > others as well)
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "Tom Ellison" <tellison@jcdoyle.com> wrote in message
    > news:ejeK5cZdGHA.3348@TK2MSFTNGP03.phx.gbl...
    >> Dear Igor:
    >>
    >> Yes! I remember this problem. There's a free third party solution, as I
    >> recall. It causes this message to be answered automatically.
    >>
    >> I'll ask around and try to find the details of what this is and where to
    >> find it. I hope I can get back to you tonight with what it was. I
    >> thought this might be enough where you might find it yourself.
    >>
    >> Tom Ellison
    >>
    >>
    >> "Ig" <Igor.Pipkin@sasktel.net> wrote in message
    >> news:12688495qelr14d@corp.supernews.com...
    >>> Hi, I need to send email from access to several clients at once.
    >>>
    >>> Private Sub cmdSend_Click()
    >>> Dim Item As Variant
    >>> For Each Item In Me!lstNames.ItemsSelected
    >>> DoCmd.SendObject , , , Me!lstNames.Column(1, Item), , ,
    >>> Me!lstSubjects.Column(1), "Dear " &
    >>> Me!lstNames.Column(0, Item) &
    >>> "," & vbCrLf & vbCrLf & _
    >>> Me!txtEMailText, False
    >>> Next Item
    >>> End Sub
    >>>
    >>> For every email address I get screen with "Outlook Express" title that
    >>> says: "A program is attempting to send
    >>> the following e-mail message on your behalf" and shows fields "To:",
    >>> "Subject:" and asks "Would you like to
    >>> send the message?" so you need for each email to confirm.
    >>> My question: how to avoid this screen? By the way it never shows email
    >>> address in this "To:" field but deliveres email without problem.
    >>> Thank you.
    >>>

    >>
    >>

    >
    >
     

Share This Page