Search results

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...

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...