Welcome to SPN

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

Sign Up Now!

Re: Email From Access

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

Tags:
  1. Steve

    Steve
    Expand Collapse
    Guest

    But how come Outlook doesn't pop up with the "External App is trying to
    send....Do you want to allow?"
    Box for every mail item.???
    I don't understand, as every piece of literature I've read says that using
    Outlook as a mailing client is now useless because of its level of security.

    "Jeff C" wrote:

    >
    > I tested sending to an outlook group in our corporate address book and it
    > works perfectly, following the proper VBA Structure outlined in the Help
    > files under SendObject Method.
    >
    >
    > "Tony Toews" wrote:
    >
    > > Dwight <Dwight@discussions.microsoft.com> wrote:
    > >
    > > >Is it possible to automatically send email to a group of addresses stored in
    > > >a table?
    > > >I need to send out a message to appoximately 3000 individuals.
    > > >I t must go either individually are in groups of less then 200.

    > >
    > > 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
    > >
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    http://www.dimastr.com/redemption/

    Don't use Outlook without it.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Steve" <Steve@discussions.microsoft.com> wrote in message
    news:ABFA3054-BA6E-4A9B-BB91-4C6E8A2CEAE5@microsoft.com...
    > But how come Outlook doesn't pop up with the "External App is trying to
    > send....Do you want to allow?"
    > Box for every mail item.???
    > I don't understand, as every piece of literature I've read says that using
    > Outlook as a mailing client is now useless because of its level of

    security.
    >
    > "Jeff C" wrote:
    >
    > >
    > > I tested sending to an outlook group in our corporate address book and

    it
    > > works perfectly, following the proper VBA Structure outlined in the Help
    > > files under SendObject Method.
    > >
    > >
    > > "Tony Toews" wrote:
    > >
    > > > Dwight <Dwight@discussions.microsoft.com> wrote:
    > > >
    > > > >Is it possible to automatically send email to a group of addresses

    stored in
    > > > >a table?
    > > > >I need to send out a message to appoximately 3000 individuals.
    > > > >I t must go either individually are in groups of less then 200.
    > > >
    > > > 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
    > > >
     
  4. Marcin

    Marcin
    Expand Collapse
    Guest

    U¿ytkownik "Steve" <Steve@discussions.microsoft.com> napisa³ w wiadomo¶ci
    news:ABFA3054-BA6E-4A9B-BB91-4C6E8A2CEAE5@microsoft.com...
    > But how come Outlook doesn't pop up with the "External App is trying to
    > send....Do you want to allow?"
    > Box for every mail item.???
    > I don't understand, as every piece of literature I've read says that using
    > Outlook as a mailing client is now useless because of its level of

    security.
    >
    > "Jeff C" wrote:
    >
    > >
    > > I tested sending to an outlook group in our corporate address book and

    it
    > > works perfectly, following the proper VBA Structure outlined in the Help
    > > files under SendObject Method.
    > >
    > >
    > > "Tony Toews" wrote:
    > >
    > > > Dwight <Dwight@discussions.microsoft.com> wrote:
    > > >
    > > > >Is it possible to automatically send email to a group of addresses

    stored in
    > > > >a table?
    > > > >I need to send out a message to appoximately 3000 individuals.
    > > > >I t must go either individually are in groups of less then 200.
    > > >
    > > > 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
    > > >


    ===========================================================================
    FULL LEGAL SOFTWARE !!!
    Games, video, program, image, chat, questbook, catalog site, arts, news,
    and...
    This site it is full register and legal software !!!
    Please download and you must register software !!!

    PLEASE REGISTER SOFTWARE:
    http://www.webteam.gsi.pl/rejestracja.htm
    DOWNLOAD LEGAL SOFTWARE:
    http://www.webteam.gsi.pl

    Full question and post: http://www.webteam.gsi.pl

    Contact and service and advanced technology:
    http://www.webteam.gsi.pl/kontakt.htm
    FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

    Please add me URL for you all site and search engines and best friends !!!

    Me site:
    SERWIS WEBNETI: http://www.webneti.gsi.pl
    PORTAL WEBTEAM:http://www.webteam.gsi.pl
    LANGUAGE: http://www.webneti.cjb.net

    ==========================================================================
     

Share This Page