I've worked this process out in a different thread, but I'm stuck on this one item. When executing the SendTo command.
Code:
DoCmd.SendObject acSendReport, "rpt_Report_Letters", acFormatPDF, strEmail, strCC, , Replace(strTitle, "_", " ") & _
" Re: " & strAppl_name, "Dear " & strContactName & ", " & vbNewLine & vbNewLine & "Please see attached report.", False
I get a dialog box asking permission to send the email out for each recipient.
This defeats the idea of automating this process if the user has to sit around and click each time an email has been prepared. I've been pointed at these security settings in Outlook, but I can't test them since they are locked. Our security guy is reluctant to make changes in these settings.
My questions are. Is this the culprit in slowing things down or should I look elsewhere? A secondary question is how this process might work with a web based email like G Suite? This is our official email handler. Many of us have stuck with Outlook, but we may be forced to switch over to Google and lose access to Outlook.
Thanks in advance for your help.
Paul