Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge query result with email addresses in outlook (Access 97)

    Hello,
    I tried to search for related topics but did't find what I am looking for.
    I have a Access database that keeps track of Trainings undertaken by different employees.
    Depending on parameters given by user I will genrate a list of employees....Till now its ok
    Now the user wants me to merge this list with the outlook address book.....show him a outlook new message window ....when he presses send, the emails should be sent to all the employees in query result.

    Thanks,
    Himanshi

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Merge query result with email addresses in outlook (Access 97)

    If you do a search on this forum (Access) for email you will find several threads dealing with similar topics. In a nutshell, you can send email from Access using the SendObject command, or you can do automation and create an email in VBA. In your case that might be the best solution as you want to send one email to a number of people and you would simply step through the query recordset to concatenate the email addresses into the TO field. This latter approach will let him review the email and decide whether to send it or not - the SendObject command is pretty automatic however. Hope this helps - if you need further clarification please post back.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •