Solved

Email created in MS Outlook using MS Access has blank Body

Posted on 2003-12-03
9
445 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
 
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Resolve DNS query failed errors for Exchange
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now