Send E-mail with multiple reciver addresses!

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

Hi!

I know how to send an e-mail with ONE reciver address, like this:
=========================================
strEmailAddress = Me.txtEmailAdress
DoCmd.SendObject acSendNoObject, , acFormatTXT, Me.txtEmailAdress, ,
strEmailAddressFrom, "E-post från Kortedala MK", , , -1
=========================================

But how do I do if I´d like to send it to several reciver address in one
e-mail?

I have a form [frmListMembers] in which I display all members with valid
membership. In this form I have a field [chkSelected] which I use to select
one or several members which I´d like to do something with (send e-mail for
instance or delete or open up another form from where it´s possible to edit
the records and so on). Now I´d like to create a function making it possible
for the user to select several members and create ONE e-mail message with
multiple reciver addresses for the selected members.

This has to be possible, right!? But how?

TIA!
// Niklas
(P.S It´s late so I won´t read this forum untill tomorrow morning.)
 
What i did was to add a new combo box and an unbound field on the report. In the AfterUpdate event of the combo box I added this code which concatenates the newly clicked address to the previous clicked addres
Private Sub Combo3_AfterUpdate(
Me.emailadd = Me.Combo3 & ";" & Me.emailad
End Su

Where Me.emailadd is the unbound field I added on the report. In your email code use this for the TO

JIm----- Niklas Östergren wrote: ----

Hi

I know how to send an e-mail with ONE reciver address, like this
========================================
strEmailAddress = Me.txtEmailAdres
DoCmd.SendObject acSendNoObject, , acFormatTXT, Me.txtEmailAdress,
strEmailAddressFrom, "E-post från Kortedala MK", , , -
========================================

But how do I do if I´d like to send it to several reciver address in on
e-mail

I have a form [frmListMembers] in which I display all members with vali
membership. In this form I have a field [chkSelected] which I use to selec
one or several members which I´d like to do something with (send e-mail fo
instance or delete or open up another form from where it´s possible to edi
the records and so on). Now I´d like to create a function making it possibl
for the user to select several members and create ONE e-mail message wit
multiple reciver addresses for the selected members

This has to be possible, right!? But how

TIA
// Nikla
(P.S It´s late so I won´t read this forum untill tomorrow morning.)
 
Hi Jim!

Thank´s for your advice! That´s quit obvoius, what you are writing, I think
I have to start using my brain a little because I did actually know this!

I´m not going to use a cmbobox for this, like you did, because I allready
have one field (chkSelected) which I can use in my code. Baut that´s not a
major problem. What I couldn´t figure out here was that I needed to
concatenate the e-mail addresses. But like I said...it´s obvious!

Thank´s for getting me on to the right track again!

// Niklas


Jim/Chris said:
What i did was to add a new combo box and an unbound field on the report.
Click to expand...
In the AfterUpdate event of the combo box I added this code which
concatenates the newly clicked address to the previous clicked address
Private Sub Combo3_AfterUpdate()
Me.emailadd = Me.Combo3 & ";" & Me.emailadd
End Sub

Where Me.emailadd is the unbound field I added on the report. In your
Click to expand...
email code use this for the TO:
JIm----- Niklas Östergren wrote: -----

Hi!

I know how to send an e-mail with ONE reciver address, like this:
=========================================
strEmailAddress = Me.txtEmailAdress
DoCmd.SendObject acSendNoObject, , acFormatTXT, Me.txtEmailAdress, ,
strEmailAddressFrom, "E-post från Kortedala MK", , , -1
=========================================

But how do I do if I´d like to send it to several reciver address in one
e-mail?

I have a form [frmListMembers] in which I display all members with valid
membership. In this form I have a field [chkSelected] which I use to select
one or several members which I´d like to do something with (send e-mail for
instance or delete or open up another form from where it´s possible to edit
the records and so on). Now I´d like to create a function making it possible
for the user to select several members and create ONE e-mail message with
multiple reciver addresses for the selected members.

This has to be possible, right!? But how?

TIA!
// Niklas
(P.S It´s late so I won´t read this forum untill tomorrow morning.)
Click to expand...
 
Back
Top