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

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -