MS Access 2007 / MS SharePoint problem with Outlook e-mail
Posted on 2011-03-24
I have recently split my MS Access database, with the backend being on SharePoint. Everything seems to work really well. Some minor issues, but no show stoppers. Well, that's what I originally thought anyway.
Here's the problem:
I have a button on my MS Access form that takes the information from the fields on the Access form and creates a formatted e-mail message. The VB code uses .HtmlBody for the body of the e-mail. When I hit the button everything works perfectly. The information is taken from the form and populated on to the Outlook e-mail just like it should; however, when I send the e-mail, all the data is stripped and left with some of the html formatting code. It is very strange. The information is there in the e-mail, but when I hit the send button, I look at the sent e-mail and the information is gone.
Even stranger is that the Subject line of the e-mail is unaffected. It works perfectly fine.
If anyone has encountered this problem or can point me in the right direction I would be extremely thankful.