Customers are not always diligent at keeping Contact information current. We may send an invoice to a contact and it may be Undelivered or Bounced, delaying payment and collections.
How do I create a NetSuite mass email campaign to each Customer Primary Contact that contains a list of all Contacts for that Customer? I need to validate all my contacts are still with the Customer and their information is correct.
11/06/2019 Clarification:
I'd like (with my fingers crossed) to be able to automatically send an email (schedule) to the Primary contact at each Customer (I created a dynamic recipient Group) that delivers only the result of my Contact saved search (listing all customer's contacts) that belongs to each Customer.
So far during my testing, A single mass email is delivered to all recipients in the Group ( To: Colleen@xxx.com, Michele@yyy.com, etc.) and contains the entire list of 2,000+ contacts. ( I also tested Bcc'ing the recipient Group but they still get the entire list of 2000+ contact list. As I tested, I expected that just had to prove it. )
My Goal is an
Email # 1: to colleen@xxx.com with search results = 3 customer xxx contacts
Email # 2: to michele@yyy.com with search results = 15 customer yyy contacts.
etc.
I will be asking each Primary contact to review their own company contact list and update as appropriate via their Customer Center.
I would think there would be a way (without scripting) I could tell the system to use the individual primary email addresses in my dynamic recipient Group and generate an email with the (sublist view) search results that relate to the Contact's Company so that each Primary contact received individual emails that only contain their Company information.
Thanks
12/17/2019 update:
Just letting all know, I have not abandoned this. I am still working on it. If anyone has another suggestion, please let me know. I will update as/if I find bump/test into a solution.