Author Topic: How to send to only one country on my list (Read 3752 times)

lynda.kane · « **on:** July 09, 2004, 03:37:30 am »

hi,

Think we need a "How do I ?" topic area :roll:

Anyway, I want to send an email just to the UK people on my list. How do I do this sort and mail?

Thanks,

Lynda

DW · « **Reply #1 on:** July 10, 2004, 10:40:32 pm »

Lynda,

Great suggestion for the new forum category, thanks!

Sending to select groups will be very easy in the next release which features "sub-list" sending based on search results in certain fields.. For the meantime, though, it's not so easy. It would involve running a custom MySQL command to move certain users to a new, temporary list. Then, send your message and use another command to move the users back. ugh :x

lynda.kane · « **Reply #2 on:** July 10, 2004, 11:38:13 pm »

Thanks Dean,

Can't wait! :wink: Any ETA on that release?

Lynda

davenet · « **Reply #3 on:** August 02, 2004, 09:35:37 pm »

I'm waiting on that feature too. I hope it's soon.

lynda.kane · « **Reply #4 on:** August 16, 2004, 11:45:04 pm »

Hi Dean,

Follow up to my question. Currently have 4 main lists - customers who bought book, came on a training, had one of our services, or signed up to our newsletter. Some people are now on all 4 lists. Tried to create an algorithm for being on only one list - doesn't really work. So to stop people getting four emails from a general send out, it would be great to have just one list, be able to code them as book, training, service or newsletter customers and then be able to send according to each of those codes, or maybe a combination of two or just to the whole list for a general mailing. Will the new "sub-list" send protocol do that and . . . . . . . . . . . .when can we have it?! :wink:

Lynda

davenet · « **Reply #5 on:** August 17, 2004, 07:55:21 am »

I think that would be a good way to do it too. I have people on multiple lists as well and would think a field (or fields) with a code to indicate which lists people are on would be very helpful. I do think the program should allow subscribers to be on more than one list. I guess implementation is the question. I'm looking forward to this feature too.

David

lynda.kane · « **Reply #6 on:** August 17, 2004, 08:51:50 am »

People can be on multiple lists!

That's the problem when you want to mail all your lists!

Cheers,

Lynda

davenet · « **Reply #7 on:** August 17, 2004, 09:09:35 am »

Well, you are right.

I'm referring to having one table though. If you have one table for all the subscribers, you need a way to assign them to multiple lists, so even though their name appears only once in the database, they can be assigned to multiple lists.

I suppose having the lists set up so that they point to records in the subscriber table might work. That way you'd have a seperate table for each mailing list with pointers back to the subscriber table for the subscribers who are members of that list. But I'm not much of a programmer, so I'll let Dean figure that one out.

The way it is now, each set of subscribers is in a seperate table. And that's where you and I are having difficulty.

David

lynda.kane · « **Reply #8 on:** August 17, 2004, 09:54:32 am »

Thanks for your reply. You've just expanded my understanding of MySQL databases by 100% :?

Lynda

AlanT · « **Reply #9 on:** September 23, 2004, 06:47:08 am »

From what I understand, when ListMail does a mailing, it creates a temporary list (the queue) of all subscribers scheduled for the mailing. In creating this queue, ListMail filters out any duplicates, so if anyone is on more than one list, they only receive one email.

From what I see, ListMail already does what you're asking about.

- Alan

PS - I'd also love to see the ability to send messages to a partial list, filtered by a query.

lynda.kane · « **Reply #10 on:** September 23, 2004, 07:47:30 am »

Hmmh,

That's interesting. would solve half the problem. Will experiment and report back. Not sure that that has been our experience. The mail to partial lists by query is of course . . . . . . . what we are all waiting for. Hint hint!!! :wink:

Lynda