sending email from Access

[Song]

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 are:
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

 

[Douglas J. Steele]

You're best off using Late Binding so that you don't need to set a reference
to a specific version.

Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm