Learn how to a build a cloud-first strategyRegister Now


Email attachments not being added (CDO)

Posted on 2011-05-12
Medium Priority
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
  • 3
  • 2
LVL 12

Expert Comment

ID: 35746362
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
ID: 35746665
Thanks for that.

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

Author Comment

by:Andy Brown
ID: 35753390
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

Amick earned 2000 total points
ID: 35753853
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: http://www.microsoft.com/downloads/en/A2ZPage.aspx

Author Closing Comment

by:Andy Brown
ID: 35862991
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
The first step to building an amazing About page is to figure out what you want the page to say about your company. You then must grab the attention of the reader, boast a bit, tell a story and let others brag about you. With a little bit of thought…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
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…
Suggested Courses
Course of the Month21 days, 6 hours left to enroll

810 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