Welcome to SPN

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

Sign Up Now!

emailing a group

Discussion in 'Information Technology' started by BernardNem via AccessMonster.com, Jul 28, 2006.

Tags:
  1. BernardNem via AccessMonster.com

    Guest

    Hello.

    My question is related to emailing a group of people in my database by using
    MS Outlook.

    I have created a database for our employees from three departments. I have
    created a form for each department and have added an action button that would
    open Outlook and enter all the emails in that form to the "To" field of
    Outlook.

    I have made a post on this and David answered my concerns...

    "The easiest way I found to do this is creating a macro per Department. The
    first field on the macro do a "set warning" and pick "No", then do
    "SendObject" and you can pick a report that you want attached to the e-mail,

    pick the object name, type of format (HTML, word, etc) then type th enames of

    the recepients on the To, CC and Bcc. the subject of the e-mail and on edit
    message if you pick yes it will open for you to add any additional tex, if no

    it will send the e-mail automatically." - David

    It has worked for me. But now i want to make it a bit more automated.

    what if i updated the form (add/delete a new email/member), how can i make
    the whole process more automated, that is, make it run through all the email
    addresses included in the form and automatically place it in the "To" field.

    I really appreciate the solution that you provided as it has given me hope to
    my project. Now, i want to know if it's possible for me to update the form
    and then it will automatically upate the "To" list.

    These are the tables and fields that I am working on. I created the query
    because I wanted to separate the employees by department. The fields below
    are the ones I needed for the query. Then I created a form based on the query
    I created so that I can make use of a button that will prompt an event. That
    event will open Outlook and enter the emails from the form in the “To:” field.


    Hope this helps. Thank you again. I really hope I can get this working.

    Table: Departments
    Field: Department_Name

    Table: Personal
    Fields: Last Name, First Name

    Table: Work
    Field: Email

    Query: Management_Query

    Form: Management_Form

    Again, thanks for the time.

    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Have a look at the sample at:

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

    "BernardNem via AccessMonster.com" <u19187@uwe> wrote in message
    news:615c83883ee6d@uwe...
    > Hello.
    >
    > My question is related to emailing a group of people in my database by

    using
    > MS Outlook.
    >
    > I have created a database for our employees from three departments. I have
    > created a form for each department and have added an action button that

    would
    > open Outlook and enter all the emails in that form to the "To" field of
    > Outlook.
    >
    > I have made a post on this and David answered my concerns...
    >
    > "The easiest way I found to do this is creating a macro per Department.

    The
    > first field on the macro do a "set warning" and pick "No", then do
    > "SendObject" and you can pick a report that you want attached to the

    e-mail,
    >
    > pick the object name, type of format (HTML, word, etc) then type th enames

    of
    >
    > the recepients on the To, CC and Bcc. the subject of the e-mail and on

    edit
    > message if you pick yes it will open for you to add any additional tex, if

    no
    >
    > it will send the e-mail automatically." - David
    >
    > It has worked for me. But now i want to make it a bit more automated.
    >
    > what if i updated the form (add/delete a new email/member), how can i make
    > the whole process more automated, that is, make it run through all the

    email
    > addresses included in the form and automatically place it in the "To"

    field.
    >
    > I really appreciate the solution that you provided as it has given me hope

    to
    > my project. Now, i want to know if it's possible for me to update the form
    > and then it will automatically upate the "To" list.
    >
    > These are the tables and fields that I am working on. I created the query
    > because I wanted to separate the employees by department. The fields below
    > are the ones I needed for the query. Then I created a form based on the

    query
    > I created so that I can make use of a button that will prompt an event.

    That
    > event will open Outlook and enter the emails from the form in the “To:”

    field.
    >
    >
    > Hope this helps. Thank you again. I really hope I can get this working.
    >
    > Table: Departments
    > Field: Department_Name
    >
    > Table: Personal
    > Fields: Last Name, First Name
    >
    > Table: Work
    > Field: Email
    >
    > Query: Management_Query
    >
    > Form: Management_Form
    >
    > Again, thanks for the time.
    >
    > --
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     

Share This Page