Thread: Tricky E-mail Function
11-27-08, 05:56 #1Registered User
- Join Date
- Nov 2008
Unanswered: Tricky E-mail Function
I have created a database of contacts which I'm hoping to also use for sending out my e-mail list. My basic idea is that I use the mail function to send to any contacts that have an e-mail address. I'm sure this is quite do-able but I have one problem. My server has a limit of sending 100 e-mails at any one time. This is to stop SPAM being sent out from the server. This would also mean though that if I wanted to send out e-mails I would need to send out in blocks of 100. For example, if there was 640 contacts. I would need to send 7 e-mails. 6 e-mails would send to 100 people each and the 7th would send to the remaining 40.
I haven't started working on this aspect of the database yet but just wanted to find out whether people thought this might be possible to accomplish using Access. If not, does anyone else have any other solutions to using Access as a source for e-mail-out information.
11-27-08, 06:20 #2www.gvee.co.uk
Provided Answers: 12
- Join Date
- Jan 2007
Should be possible; here's some pseudo-code to get you started
declare counter declare record_counter integer declare recipients string declare total_records integer Open recordset for email addresses from table set counter = 0 set record_counter = 0 set recipients_list = "" set total_records = count of records in recordset While Not end of recordset set recipients_list = recipients_list & email_address & "; " set counter = counter + 1 If (counter >= 100) or (record_counter = total_records) Then sendemail to recipients_list set counter = 0 set recipients_list = "" End If record_counter = record_counter + 1 Go to next in recordset
11-27-08, 17:37 #3(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
also one thing to think about
do you want to saveit in the Sent Items
I wrote a bulk email send for our CMS the problem i had was they were attaching a big PDF and the mail box was full up with sent items so all i did was add the .DeleteAfterSubmit = Ture them send it and .DeleteAfterSubmit = False after the send.hope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON