Email created in MS Outlook using MS Access has blank Body
Posted on 2003-12-03
I am using MS Access to send emails via Outlook.
I have Access 2002 and Outlook 2002 running in XP
I have used the following code to send emails without any problems from numerous computers.
But for one computer everything works, ie the email is created, but the Body section of the email is blank. I have checked the contents of the string via the msgbox and the information exists to insert into the body of the email, but when I open it in the Outlook Outbox, the text is just not there, the body of the message is blank.
Set mItem = mOutlookApp.CreateItem(olMailItem)
mItem.Subject = strsubject
msgbox strmsg 'used to check strmsg has content
mItem.Body = strmsg
mItem.SentOnBehalfOfName = strsender
As it is not a problem I have experienced on any other machine it is difficult replicate it when I am working at the office to develop the programme.
Any suggestions of what the bug might be.