Sending Email Bulk - i really need help thanks! :) 6

[asafb]

Hello, can someone help me - i want to create a button that when you press it it will take all the emails from all of the records in the recordset of the form and open outlook and it will show in the to box like this

( i have email field in the table )

Record 1 email address george@nyc.rr.com
name george


Record 2 ...

like this in outlook:

To: george@nyc.com, smith@sam.com, george@george.com

anyway to do this?

i already have the SQL statements and everything

Anybody know?

Asaf

 

[JamesTV]

Ok thanks I had a feeling it might be something like that. So I set a field named EMailFlag as a yes/no box
and have a seperate field containing the e-mail address?

Could you give me an idea of the fields to implement in a simple e-mail table test this out so it works without having to change the code?

Greatly appreciated

 

[pyoungmwl]

This is my layout for tblEMails:-

Surname Text
Forename Text
Title Text (Mr Mrs etc)
E-Mail Text (E-Mail Address)
Division Text (Used at an earlier stage to select from a main table - not really relevant or necessary here)
EMail Flag Yes/No

My original database extracts names from the main table based upon membership of one or more divisions and the existence of an email address on their records - the user is then presented with a screen where all those selected are ticked by default but they can be unticked if no email is required.

 

[JamesTV]

Great thanks. I'll get back to you if there are any more problems. I should be ok now though.

 

[JamesTV]

Ok, I've got everything working however when I get to the final step the e-mail doesn't send automatically. It stays in the Outlook window and I have to click send yet your code shows that it should send automatically and close. Not sure why but can you shed any light on what may be wrong here? There's a big shiny star in it for you!

Thanks again.

 

[JamesTV]

no worries, it works

 

[atiaran]

Hi Asafb

I was going thru this thread and you were asking the question where to paste the code. Could you tell me where you pasted it as I couldnt figure out where to put it. It would not work if it is being put in that section that you access via the Event Procedure of the OnClick property of the form.

Thanks a lot. Greatly appreciated.

 

[pyoungmwl]

The way I did this originally was to design a form which extracts the desired recipients - I put a Yes/No field on the form to highlight the relevant records - and then attach the code to a command button on the form.

 

[atiaran]

Hi pyoungmwl

The code is great and works perfectly. A big star for you.

Thanks a lot.

Atia