At the moment I email my Statement and Invoice separately from deactivation of my Reports all works fine, but now I want to email my invoices with each statement. Statement is controlled by the date range set and has the Field "OwnerID" which is the same field in my Invoices. So when I select a Statement Report for say 1st Feb - 28 Feb for OwnerId = 23 it will add his invoices from 1stFeb - 28 Feb with his Statement. Everything is set up for emailing just need to combine the 2 together
Part of my Email Code below:
? [login to view URL] acSendReport, sndReport, strFormat, strMail, Cc:=DLookup("EmailCC", "tblOwnerInfo", "OwnerID = " & lngID), Bcc:=DLookup("EmailBCC", "tblOwnerInfo", "OwnerID = " & lngID), _
? ? ? Subject:="Your Statement" & " / " & Nz(DLookup("[CompanyName]", "tblCompanyInfo")), MessageText:=strBodyMsg
? ? ? ? ? ? ? ? ? ? ? ? [login to view URL]