Solved

Email created in MS Outlook using MS Access has blank Body

Posted on 2003-12-03
9
449 Views
Last Modified: 2010-04-08
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.Recipients.Add strRecip
    mItem.Subject = strsubject
    msgbox strmsg   'used to check strmsg has content
    mItem.Body = strmsg
    mItem.SentOnBehalfOfName = strsender
    mItem.Save
    mItem.Send

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.

Richard
0
Comment
Question by:richardhubbard
  • 5
  • 4
9 Comments
 
LVL 23

Accepted Solution

by:
slink9 earned 250 total points
ID: 9865802
Something is wrong with that installation.  Try a Detect and Repair.  It is in the Help menu.
0
 
LVL 1

Author Comment

by:richardhubbard
ID: 9865938
I passed on the instructions to run this and I will let you know the outcome.
Many thanks.

Richard
0
 
LVL 1

Author Comment

by:richardhubbard
ID: 9876177
Detect and repair has been run, but it has the same problem.
Do you have any other suggestions I can try??
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 1

Author Comment

by:richardhubbard
ID: 9891354
Just checked with the user of the programme again, and it was another problem he was referring to.
The email aspect is now working, so Detect and Repair seemed to have done the trick.
Many thanks and points well spent.

Richard
0
 
LVL 23

Expert Comment

by:slink9
ID: 9891755
Why a B?
0
 
LVL 1

Author Comment

by:richardhubbard
ID: 9894750
I guess I have not understood the grading system.
Please tell me if my thinking is wrong.
In the past I have asked a question where the expert clearly spent some time researching and testing the answer.
You were able to answer my question, for which I am very grateful, but it was from existing knowledge of the program, knowledge I did not have but do now.

I would give the first expert the highest grade because of the time clearly spend finding the right answer for me. If I gave the same grade here would it not devalue the grading system?

Sorry if I have offended, I did not intend to, just wanted to reflect what I thought was the appropriate response.

If I have got this wrong and I am able to, I will change the response.


0
 
LVL 23

Expert Comment

by:slink9
ID: 9895742
That thinking is somewhat amiss.  I did not get the knowledge that emailing from other programs works by accident.  I was not born with the ability to review the code you posted.  I also did not magically "know" Outlook, but have to use it myself and experiment with many procedures to gain more and more knowledge on it.
Yes.  That was a simple solution, but it still deserved an A.  That is sort of like basing the grade on the amount of time taken to answer.  The solution may have come 30 seconds after the question, but it could also have resulted from months of research which ended with one or two highly detailed links.
0
 
LVL 1

Author Comment

by:richardhubbard
ID: 9896151
Sorry - is there anything you want me to do?
0
 
LVL 23

Expert Comment

by:slink9
ID: 9896193
No problem.  Just explaining the situation.  There are some who never give good grades.  They don't get much help after a few times of that.  We all come in and make newbie mistakes.  No biggee.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question