View Single Post
  #1  
Old May 12th 08, 11:58 PM posted to microsoft.public.access,microsoft.public.outlook,microsoft.public.outlook.program_vba
John[_11_]
external usenet poster
 
Posts: 30
Default Late binding code

Hi

I have the below code to send an email from within MS Access using Outlook.
What would be the late binding version of this code?

Many Thanks

Regards


Dim OutlookApp As Outlook.Application
Dim ns As Outlook.NameSpace
Dim EM As Outlook.MailItem

Set OutlookApp = New Outlook.Application

Set ns = OutlookApp.GetNamespace("MAPI")
ns.Logon

Set EM = OutlookApp.CreateItem(olMailItem)

With EM
.To = "
.HTMLBody = "Something here..."
.Attachments.Add a(I)
.Display (False)
End With

Set EM = Nothing


Ads
 

0 Credit Cards - Personal Loans - Free Ringtones - Loans - Buy Anything On eBay