email from access 2

[mikeba1]

I am writing a small access aplication with email output via Outlook.
I have written and tested the following which works

Set objOutlook = CreateObject("Outlook.application")
Set objEmail = objOutlook.CreateItem(olMailItem)
With objEmail
.To = ema
.subject = noteb
.body = notec & Chr$(13) & notea & noted
.Send
End With

However I have now been told that som clients use Outlook Express as opposed to Outlook.
What are the differences if any and if so how can I identify which client
Thanks

 

[Remou]

As an alternative, there is CDO and SendObject.

 

[SeeThru]

You only really need to use the full outlook thing if you are adding attachments or need more complex manipulation - use the simpler SendObject otherwise...

 

[Remou]

If you still wish to find out the email client, this may help:

Set ws = CreateObject("WScript.Shell")
MsgBox ws.RegRead("HKLM\SOFTWARE\Clients\Mail\")

 

[SeeThru]

Oooh - that's cool. I like that....

 

[mikeba1]

Thanks guys