Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page