Solved

How do I generate emails from Access 2013

Posted on 2014-12-26
7
153 Views
Last Modified: 2015-01-29
Hi Experts,
I need help generating emails from my Access 2013 application.
I have a table with employee names and employee email addresses (tblEmployees).
I have a List box control that will list the email addresses.  I want to be able to select one or more email addresses from the list box, and then click a button to send a pre written email message.  How can I do this ?

Thank you very much in advance,
mrotor
0
Comment
Question by:mainrotor
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40519258
here is the code to get selected emails from a multi select listbox

Dim j,strEmails
 With Me.listEmail
     If .ItemsSelected.Count > 0 Then
         For Each j In .ItemsSelected
           strEmails =strEmails & ";" & .ItemData(j)  'collect all selected items as strEmails
         Next
     End If
 End With
 strEmails= mid(strEmails, 2)
0
 
LVL 84
ID: 40519534
When you say "pre-written", do you mean the user has already written an email in their email client? Or that you want to have the user write the email in Access, and then select the recipients in your listbox and send that email?

Rey has shown you how to collect the selected items from the listbox, but to send the email you can either use SendObject, or use automation.

SendObject is used like this:

DoCmd.SendObject acSendNoObject, "", "", strEmails, "", "", "Email Subject", "Email Body"

 http://msdn.microsoft.com/en-us/library/office/ff197046%28v=office.15%29.aspx

There are some limitations to SendObject - for example, you can't send HTML emails, messages are limited to 255 characters, you can't attach files from disc, and the security mechanism in Outlook can cause troubles. If you need that additional functionality, you can automate Outlook. This article shows how to do that:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/A_4316-Automate-Outlook-in-VBA-with-the-OutlookCreateItem-Class.html
0
 

Author Comment

by:mainrotor
ID: 40521346
Thank you both for your help.  How about if the users use Yahoo, or G-mail for sending emails, could this be done?  

Is outlook the only way this could be done?

Thank you,
mrotor
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40521668
You could, but not with Outlook Automation. Instead, you'd use CDO to do this. There are several questions here on EE that show how to do that, for example:

http://www.experts-exchange.com/Database/MS_Access/Q_21601489.html

You'd have to change the SMTP Server and Port to match those expected by the email server, of course.

There's also VBSendMail. As with CDO, there are many questions that address using vbSendMail, like this one:

http://www.experts-exchange.com/Database/MS_Access/Q_28093260.html
0
 

Author Comment

by:mainrotor
ID: 40528633
Thanks Scott,
I will checkout those links.

mrotor
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40577051
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

830 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