Email attachments not being added (CDO)

Posted on 2011-05-12
Last Modified: 2012-05-11
I have an Access database that can send out HTML emails via CDO.  This has worked fine for some time, but I have a new client who, on occasion, when they send emails the logo does not appear (just the red cross).

The way it currently works is a html file is generated, and then any attachments relating to the html file are copied to the same folder.  I then use the ".CreateMHTMLBody" command to put everything together.  As mentioned above, this has worked flawlessly for several months - just not on this new site.

I now have an exact copy of the clients database and when I run the test here - it's perfect.

There machines are mostly running XP and I wouldn't like to guarantee that everything is up to date, but I could just do with a little guidance before going back to them.

Thanks as always.
Question by:Andy Brown
    LVL 12

    Expert Comment

    The most common cause is that the logo image is inaccessible.  If the logo is in the database and it works perfectly at your site but fails intermittently at their site, is there a security setting which prevents some users from accessing the image?

    If the image is not in the database, is the path to the image accessible by all users? Are you using a path or share-name that may be different in some configurations?

    Author Comment

    by:Andy Brown
    Thanks for that.

    It might be the security - i'll check it out,

    Author Comment

    by:Andy Brown
    It appears to only be a problem on the older XP machines, which I have a feeling don't have the latest updates.  Is there an update that we can download onto those PCs that ensures we have he latest CDO capabilities?
    LVL 12

    Accepted Solution

    It depends what version of Access you're running.  In Access 2007 go to Access-Options>Resources>Check for Updates to retrieve your updates.

    If the XP machines aren't using the Automatic Update feature, you might enable it to get the latest patches.

    If you want just CDO try:

    Author Closing Comment

    by:Andy Brown
    Sorry for not getting back to you sooner.  

    In the end they decided to upgrade their PCs to Win7 - as soon as they did all problems disappeared.  That said, your CDO link may come in useful in the future.

    Thanks again for your help.

    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

    Hello Friends, My friends and relatives always ask me how to delete all the various types of emails at once in our g-mail  or windows live account.  So I researched this topic to find a unique solution to this query.  Here it is for those who do …
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    728 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