View Single Post
  #1  
Old June 2nd, 2010, 07:40 PM posted to microsoft.public.access
Song[_4_]
external usenet poster
 
Posts: 43
Default sending email from Access

I use reference to Microsoft outlook 12.0 Object Library. (Access
2007)

Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Dim ctlBody As String

Set olApp = Outlook.Application
Set objMail = olApp.CreateItem(olMailItem)

Set objMail = Nothing
Set olApp = Nothing

The above code has no problem for Access 2007. My questions a
1. What if users upgrade to Office 2010? Do I have to change the code?
2. What if users do not use Outlook, instead, they use Windows Live
Mail? How do I change the code?

Thanks.

Song