Send HTML email in MS Outlook using MS Access?

I have figured out how to email using MS Access but when the message I create has a link, it does not activate to be clicked in Outlook (or in the emails I have sent to myself to test). I think what I am missing is to change the type of email to HTML.





Can someone tell me how to do this and what coding I need to make the links active? I am using a button to email one customer at a time, please factor this into the code.
Send HTML email in MS Outlook using MS Access?
Add the Outlook library to your code.





Then use this sequence.





Set objEmail = CreateObject("Outlook.Application")


Set objOutlook = objEmail.CreateItem(olMailItem)





objOutlook.Recipients.Add thisEmail


objOutlook.HTMLBody = mySPAMmessage





objOutlook.Subject = "[SPAM] " + SpamSubjectText





objOutlook.Send





OH, but don't use this to send SPAM. Develop a table of "DO NOT SEND" e-mails, so people don't complain a second time.





Good luck
Reply:You can use CDO to send emails without needing to activate Outlook in any way (or even having it on your computer). Take a look at http://www.paulsadowski.com/WSH/cdo.htm