?
Solved

MS Access 2003 - reference set to "SMTP Send Mail for VB6.0"

Posted on 2009-04-30
6
Medium Priority
?
733 Views
Last Modified: 2013-12-17
I found a solution on the site to send emails from MS Access through Outlook.  But the solution informs in the VBA code that:

'Make sure you have a reference set to "SMTP Send Mail for VB6.0"
'(Menu bar --> Tools --> References)
'The list of attachments is expected to be a semi-colon delimted list.

I cannot find this reference on my list.   As a result, when I debug I get the message User-defined type not defined on:  Dim poSendMail As vbSendMail.clsSendMail

How can I solve this ?
0
Comment
Question by:vanmaele
  • 3
  • 3
6 Comments
 
LVL 58
ID: 24274039
<<I found a solution on the site to send emails from MS Access through Outlook.  But the solution informs in the VBA code that:>>
 That solution does not send e-mails through Outlook, but directly to a SMTP server.
 
<<I cannot find this reference on my list.   As a result, when I debug I get the message User-defined type not defined on:  Dim poSendMail As vbSendMail.clsSendMail>>
  you need to add the reference to the .DLL.  From the reference dialog, click the browse button, locate the reference and add it to the list.
JimD.
0
 

Author Comment

by:vanmaele
ID: 24283927
Hi Jim,

I Opened Tools > References, but I cannot find it on the list.  Please take a look at the screenshot.  
Screenshot-DB.doc
0
 
LVL 58
ID: 24283950
It won't be in the list.  You need to click the browse button, locate the .DLL and select it.  It will then show up as:
"SMTP Send Mail for VB 6.0"

  You need to check it and then click OK.
JimD.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

Author Comment

by:vanmaele
ID: 24284048
Hello,
I found a DLL called sendmail.dll (I suppose this is the one).   But now I get another error: can't add the reference...
Screenshot-DB-2.doc
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 24285923
<<I found a DLL called sendmail.dll (I suppose this is the one).   But now I get another error: can't add the reference...>>
That's the wrong .DLL.  You want vbSendMail.DLL, which is part of the download found here:
http://www.freevbcode.com/ShowCode.Asp?ID=109 
JimD.
0
 

Author Closing Comment

by:vanmaele
ID: 31576637
Hi Jim,
Excellent !   This was exactly what I needed.  Thanks a lot !!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Suggested Courses
Course of the Month16 days, 1 hour left to enroll

850 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