Two problems I'm having sending e-mails with DoCmd.SendObject in Access
Posted on 2011-03-11
I am developing an Access 2007 "project" (.ADP) as the front-end to a SQL Server 2005 Express database.
From within the Access application I am using some VBA code to send e-mails with ".pdf" attachemnts as below :
DoCmd.SendObject acSendReport, strReportName, acFormatPDF, _
strAddrEMail, "", "", _
strEMailSubject, strMessText, False
I have two problems :
1. The text for the "body" of the e-mail is passed in via "strMessText" and appears in the e-mail OK, but the e-mail body also contains the characters "<<...>>" in the first line of the e-mail, above my intended text. Can anyone tell me why this is, and how I can get rid of it?
2. This code is used to issue several e-mails to different customers in a single session, but for each e-mail I get the Outlook security warning telling me an e-mail is being sent, giving the options to "Allow" or "Deny". This is not a great problem when only a couple of e-mails are being sent, but a real pain when dozens are being issued.
From the Google results I have found, this does not appear to be easily removed and requires some VBA coding in each Outlook instance being used. Does anyone have a simpler solution to this, so that the security warning can be by-passed?
Many thanks. Colin.