Solved

Email created in MS Outlook using MS Access has blank Body

Posted on 2003-12-03
9
451 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Create Professional Looking Email Signatures

Create "Professional HTML Email Signatures" with ease.
7 Day Money Back Guarantee if not 100% Satisfied.
Affordable - Try it out for 7 Days Totally Risk Free.
Installers provided for over 45 Email clients.
Both Windows & MAC Supported.
Highly Recommended!

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you don't know how to downgrade, my instructions below should be helpful.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
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…

738 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