Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    58

    Red face Unanswered: Email each contact in a list

    Hi all,

    I am trying to send an email to everyone in a list of contacts from within access.

    So far i can send an email (opens up outlook with the email address, subject etc)to the first contact, but it will not open any further windows in which the other addresses should be shown.

    How can i send the email to all contacts within that list?

    so far the code goes..

    DoCmd.SendObject acSendQuery, "Q-List PO Email", acFormatXLS, [EMail], , , "Unique Number" & " " & [Unique_Number], "Dear" & " " & [FullName], True

    Jnr.

  2. #2
    Join Date
    Nov 2003
    Posts
    43
    Have a look at this ! That should help.

    http://www.rogersaccesslibrary.com/O...sp?SampleName='CodeSendEMailToAll.mdb'

Posting Permissions

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