sending email from Access



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

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?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question