RE: [AccessDevelopers] Problems emailing from Access 2003

[Lava Boggavarapu]

I had this problem once.   You will need to pass in the actual value (0, I think). Some versions, don’t resolve this constant to the actual value.   Lava   ------------------------------------------------ Lava Boggavarapu Lava Trading Inc. 95 Morton Street New York, NY 10014   Tel 212.519.9371 Mobile 732.668.2935 www.lavatrading.com -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Cathy Jupp Sent: Tuesday, December 20, 2005 10:38 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Problems emailing from Access 2003   This is a really annoying one because it works on some machines but not others, and I can't see the difference.  I'm hoping it might be blindingly obvious to someone here what is wrong. I'm using code within an Access 2003 module to send an email via Outlook 2000.  The relevant part of the code is as follows: Public Sub send_email_externally(EMail_who_to, Email_subject, Email_Message, Optional Email_attachment)   'Make Outlook message   '====================   Dim ol As New Outlook.Application   Dim olItem As Outlook.MailItem       Set olItem = ol.CreateItem(olMailItem) It errors on the last line - Run-time error '48': Error loading DLL, but as I mentioned, only on some machines.  All of the computers I've been looking at have the same references loaded, all have the whole of Access 2003 and all of Outlook 2000 installed. Any clues, anyone? TIA Cathy The information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages. Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.