Search results

  1. A

    Issue with email format

    That worked I reset my, strEmailMsg & everything works perfectly. Thanks!!
  2. A

    Issue with email format

    I have this code that works perfectly except that in the Message/Body of the email it sends out each invoice to every employee, rather than just sending the invoices related to each employee. Public Sub SendMail2() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim...
  3. A

    Emails multiple lines from query to 1 recipient

    What do you suggest?
  4. A

    Emails multiple lines from query to 1 recipient

    I have it working but when it gets to the last record to populate in the body of the email I get an error 'No Current record'. It does not send the email or populate the last invoice line in the body. I am missing something to do with the recordset but am drawing a blank. Public Sub SendMail()...
  5. A

    Emails multiple lines from query to 1 recipient

    I put another loop into it but it's giving me the same line for each invoice record. It's not moving to the next record. The results are still multiple emails with the same invoice line in the body of the email rst.MoveFirst Do Until rst.EOF Set aOutlook =...
  6. A

    Emails multiple lines from query to 1 recipient

    Can I get an example?
  7. A

    Emails multiple lines from query to 1 recipient

    Email multiple lines from query to 1 recipient I have some VBA that pulls in a query and sends an email to the requestor. I would like that same coding to loop through the query data to send multiple lines to one email recipient. Meaning 1 person could submit multiple invoice lines so in the...
Top Bottom