Forums

In CC6 I have a table of member names and email addresses. The table has codes for different member categories. I would like to send emails to members coded in a specific category. So say I have 100 members and 25 of them are in category 1. How can I send separate emails to just the members in that category. Can I do separate emails (same content, but individual emails). Or do the addresses have to be on one email with multiple addresses?

How do I specify that I want to read the database and select by category rather that hand code the addresses?

Thanks,
Karen K

Hello Karen,

If you can get a list of the members addresses then you can add it in the "Recipients" list of the email action OR loop through the list and execute a new email action each time.

How to retrieve the list of emails depends on your database table setup which I do not know.

Best regards,
Max

Thanks,

Sorry for the delay in my response. Too much going on.

The email addresses I want to send are in a db table and there are many of them. So your first suggestion of adding the addresses to the Recipients list is not feasible.

Can you tell me how to set up a function to loop through the table and execute an email action each time. Basically I want to just read each row of the input table and send the emails automatically without having manual intervention with each row.

kkurtz

Hi kkurtz,

How many is 'many' - if there are hundreds rather than tens you might want to look at using something like AcyMailer to handle the mailing part of the list as it will be better at handling larger quantities of emails.

Bob