I'm finding the template design to send out a montlhy newsletter rather difficult for the average person. I want to be able to merge customer record fields in the template which I can, but I also want to merge specific "newletter" data in the template (e.g. special content, dates, content authors, etc). In other words, I want to create a custom record where the marketing person can simply enter the title, content (or contents) in HTML, links to pictures, and so on and somehow "point" this to the template on merge to add the content. This way, I build a shell template and then combine the customer fields and the newsletter fields. Finally, I want to be able to still send as a campaign which I can track.
First question: Is there anyone who has done this sort of thing already? If so, how?
If above has not been done, then one thought is below but I'm not sure the capabilities are all there in NetSuite or not, so looking for some verification or alternative ideas.
1. I create a custom record that contains the main newsletter field info I care about.
2. I create another custom record which contains the content specific fields and I link these to the main newsletter record (so I can have multiple content items).
3. On save, I run a script that will:
a. Load a shell template file from the templates section of the File Cabinet.
b. Take the custom record information and "create" or "update" (if already exists) a template file based on the title or ID of the custom record in the File Cabinet.
c. Save this pre-merged template for use by normal template merges within NS.
4. I go to the campaign and select the template just created/updated and perform my normal email/merge with the selected customers.
This in theory seems to make sense that it would work, but I'm not sure if I can create/edit a marketing template file from a suitescript.
Ideas? Thoughts?
Thanks.
-Steve