Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Question Unanswered: Send one Email to many from Addresses in table

    hi there

    i can send an email to each person in the table, but how do i send one email and cc in other names in the table? I have a type field (To or CC or BCC)


    currently using, which is great for opening lots of emails.... just want one...
    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset
    Dim strSQL As String

    strSQL = "Select emailaddress from tbl_Email where update = true"
    rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockReadOnly
    rs.MoveFirst
    Do While Not rs.EOF

    DoCmd.SendObject acSendReport, "rpt_ContractorListForIT", acFormatXLS, rs!EmailAddress, , , "Contractor Expiry Dates", strMess


    rs.MoveNext
    Loop
    rs.Close
    Set rs = Nothing

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    DoCmd.SendObject acSendReport,<ObjectName>,<OutputFormat>,<To>,<Cc>,<Bcc>,<Subject>,<MessageText>
    You can separate addresses with semi-colons ( like this
    Code:
    DoCmd.SendObject acSendReport,<ObjectName>,<OutputFormat>,<To>,"me@me.com; you@you.com"
    George
    Home | Blog

Posting Permissions

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