For me, I am driven by two main philosophies: know more today about the world than I knew yesterday and lessen the suffering of others. You'd be surprised how far that gets you.
I am going to add 1000 new customers to my CustomerT. I want to subscribe these new customers to a single mailing list. Is there a way to automatically subscribe them without having to march through a 1000 different customers and manually subscribe them to a Particular mailing list you can imagine how much time it takes to manually go through 1000 enrollments. Any help will be greatly appreciated.
Kevin Robertson
@Reply 8 months ago
If they are new records set the Default Value for that Field.
For existing records use an Update Query
Larry FisackerlyOP
@Reply 8 months ago
These will be new records. I don't know what table to set the default value in. The customer table does not store mailing list values. The only place I see mailing list values stored is in the CustomerXMailingListT. That is the junction table that ties the customers to the mailing list. That table only contains customers that have already been assigned to a mailing list. So when I import the new 1000 customers, they are not going to show up in the junction table because they have not been assigned a mailing list ID. That's where I'm having a problem I don't know where to or rather which table to assign the mailing list ID to. I know how to manually do it in the customer form but it's unreasonable to march through 1000 customers to assign a mailing list to. I keep thinking there has to be a way to automate this for initial import a thousand or several thousand emails.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Email Seminar Lessons.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
