Sending Multiple Emails

Brendan Bartley · January 21st, 2009, 12:24 PM

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

Regards

SerranoG · January 23rd, 2009, 01:07 PM

For each radio button selected, you can issue a DoCmd.SendObject command to send an e-mail for each task.

kuznickic · January 25th, 2009, 01:49 AM

I think the best way to do this is this.

Code:

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.

Chris