email - Adding external attachment an mailing from Access -
I am trying to send email using MBBA from VBA but can not use sendobject function because This external support does not support file attachments.
Does anyone know how I can do this?
Thanks
Anyone can use MAPISession control in VB 6.0, So I think it will also be available in VBA
Another way is to use the Outlook object model, but MS Outlook will be required to install it. Although most of the users with access usually also put Outlook on their desktop
and then another decision - you can use .net (VB.NET for exbaple) to write a very small component. That SmtpMail will use System.Net.Mail to write and send. It will not be very difficult for you as a VBA developer. If you can write a class with a function SendEmail, then you can show this class to COM, then you will have an ActiveX DLL, which you call from your VBA project (Using the CreateObject ("")) and
Comments
Post a Comment