Hello All I have a request to build a db which will generate email to a recipient list of 3000 members. The list can be found within a first sorted column in a view within in the db. I want to send 100 emails at a time every 5 minutes or so, until the 3000 recipients are exhausted. I have created a profile doc to hold the email text so this can be easily changed for other purposes as well.
Does anyone have any suggestions or examples to accomplish this?
Much Appreciated,
Pat
Subject: Email Generator
Sounds cumbersome. Can your database not create a group in the Name and Address book of all 3,000 names, and just mail to that ? Let the server do the work of sending all the mails.
That presumes the e-mail is identical for all recipiants. If it needs to be customized for each name, then you’ll have to continue with the original design.
I would do the following.
Have a special document holding the 3,000 names that the mail should be set to.
Have an agent running every 5 min’s.
Have the agent read up to 100 names form the special document, and send the mail.
Delete those names from the special document.
Subject: RE: Email Generator
Our Notes Admins only allow us to send 100 emails at a time and I don’t want to maintain 30 distribution lists.
Subject: RE: Email Generator
When you say 100 emails at a time I presume that you mean 100 recipients in an email at a time.
If so you could send all the emails in one run of the agent by composing the email and then putting the first 100 recipients in the SendTo field and sending. Then carry on looping through the list of recipients putting in a 100 names at a time and sending.
Subject: RE: Email Generator
Thanks Matt, Yes that would be feasible however, the admins don’t want me to flood the gates all at once with 3000 recipient emails.
Subject: RE: Email Generator
There are ways around it. Can you confirm how your email recipients are stored in the database. i.e. is there one document per recipient or are they all stored in a field in one document.
Also is this to be a one off email or is it to be sent on a regular basis.
Subject: RE: Email Generator
There is one document per recipient and this a one off email
Subject: RE: Email Generator
One way to do this is to set a flag on the documents that you have already processed.
e.g. send the email to the first 100 recipients and set a flag field MailSent on those documents to “Yes”. Next time the agent runs only process the documents where this flag has not been set and so on.
As it is a one off, disable the agent after it has run on all the documents and to tidy up run an agent that removes the flag field.
Subject: RE: Email Generator
Matt - That’s what I was thinking. Thanks for confirming.
Pat