Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 21st, 2009, 12:24 PM
Friend of Wrox
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sending Multiple Emails

Hi All Again
I have a form that has a selection of radio buttons for different services available. Is there a way that allows if the user selects several services from the form that it will send multiple e-mails to the different service groups

Brendan Bartley
Old January 23rd, 2009, 01:07 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

For each radio button selected, you can issue a DoCmd.SendObject command to send an e-mail for each task.
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
Old January 25th, 2009, 01:49 AM
Authorized User
Join Date: Feb 2005
Posts: 47
Thanks: 2
Thanked 0 Times in 0 Posts
Default Respnse for sending multiple emails

I think the best way to do this is this.

Dim strAccountingEmail as String
         Dim strHREmail as String
         Dim strAccountingSubject as String
         Dim strHRSubject as String
         Dim strAccountingBody as String
         Dim strHRBody as String
Now that have these string variables you can assign them to values that are on your form.
On the DoCmd.SendObject function in your code you can then pass the string variables as arguments to it. The way you would declare the DoCmd and the way you pass the variables to it really depends on if all the services would receive the same information or not. The only to really know is if you could post the file you are working on. You could also add DoCmd's programmatically if the user selects multiple services. Hope this helps.


Similar Threads
Thread Thread Starter Forum Replies Last Post
sending emails for all users in the domain arabuafef ASP.NET 1.0 and 1.1 Basics 6 December 6th, 2006 10:51 AM
Sending automatic emails maitias C# 2005 3 March 3rd, 2006 09:51 PM
Sending emails from smartphone application. unprsandeep C# 0 March 24th, 2005 02:01 PM
Sending automatic emails in Access marcin2k Access VBA 10 March 6th, 2005 03:48 PM
sending emails from vb.Net elan22 General .NET 5 May 27th, 2004 08:53 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.