Welcome to SPN

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

Sign Up Now!

Is There A Way To Use An Access Database To Send Group Emails

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

  1. DaisyLady

    Expand Collapse

    doing some work for a friend setting up a client database for her shop, she
    needs to be able to send an email to remind people once a week when they're
    appointments are for that week, is there anyway to use an exsisting access
    database which contains the email addresses of the clients and the date of
    their next appointment to send them an email semi automatically rather than
    go through the diary and do it manually in outlook express (which is how she
    does it at the moment)

    Cheers Nic
  2. Loading...

  3. OP

    Expand Collapse

    Here's a code snippet to send an e-mail from Access:

    DoCmd.SendObject , , , “tosomeone@domain.comâ€, , , “Message Subjectâ€,
    “Message body here.â€, False

    You can tie that code to a button click if you'd like, and use VB to
    populate the e-mail, subject and body.
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page