Skip to main content
A
Anonymous
October 18, 2011
Answered

pull emails off database

  • October 18, 2011
  • 1 reply
  • 1713 views

DW CS3 - ASP VBScript - Access

How do I do this?  I'd like to pull emails from all records in a table where a specific column is checked Yes (subscribed), in order to send group email.

Are there scripts to handle this?

This topic has been closed for replies.
Correct answer bregent

Then you just need to search the web for something like 'asp mail list script'.  The basic concept is simple. Load the addresses into a recordset, and loop through the recordset adding addresses to the email bcc field.  Because mail servers have max address limitations, it also needs to have another loop to break the records into smaller sets of 25-50 addresses.

1 reply

B
bregent
Participating Frequently
October 18, 2011

There are scripts out there, but it's a pretty simple loop you can write yourself. Much of how you do it depends on how large a group you are mailing. What is the size of the list?

A
Anonymous
October 18, 2011

Nothing over 300 recipients, but that number will change. Unfortunately, I have email limitations and may eventually resort to an email marketing system.  For now, I'd like to try a simple ready-made script if available, with instructions.

B
bregentCorrect answer
Participating Frequently
October 18, 2011

Then you just need to search the web for something like 'asp mail list script'.  The basic concept is simple. Load the addresses into a recordset, and loop through the recordset adding addresses to the email bcc field.  Because mail servers have max address limitations, it also needs to have another loop to break the records into smaller sets of 25-50 addresses.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices