Recent content by pnevilm

I have some VBA code that works to send an email with several daily reports to one person, but I want to send these same reports to multiple recipients. I cannot reconcile the TO in VBA. Its probably something simple, but I am racking my brain testing this. Can anyone help? Here's what I have...

I used to get this same message due to the security settings in Outlook. Change your security settings. I am using Access 2007, and the code I use to send a standard email with attachements is: Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As...

Do you have a similar solution to sending multiple reports in a single email? I am using MS Access 2007 with MS Outlook. I have looked EVERYWHERE!!!!

I am trying to automate sending daily reports to a select list of internal employees, and Access 2007 is only letting me send one at a time, not multiple reports in a single email. Not only do I have this problem, but, each time I try to send one usingthe macro function (this is one report for...