Question
I have a database with several hundred thousand member entries. I want to send out a message but I want different groups of members to get different messages. Specifically I want to easily include in the message different URLs where that URL is made up of details included in that person’s
database record. E.g. user1,1234,abcd gets the url
http:\www.mysite.dom1234abcd.htm
Answer
This is an extremely good example of just what GMS Communication Server can do.
If you have your information in a database table, it might have columns like:
| Domain gordano.com ntmail.co.uk |
User support user |
ItemA asdf iei |
ItemB 93 3 |
When an email message is sent to a list with associated with this database table, it might have the following MML code in it:
EG> EG> Hi print(user);, EG> EG> Please click on this URL: EG> http://mysite.dom/page1/item.htm?id= print(ItemA, “&x=”, ItemB); EG> |
When this is sent to the list, it would end up being customised for each list member according to the fields in the database table:
EMAIL1> EMAIL1> Hi support, EMAIL1> EMAIL1> Please click on this URL: EMAIL1> http://mysite.dom/page1/item.htm?id=asdf&x=93 EMAIL1>
EMAIL2> |
Keywords:Customise MML List Database ODBC Access GLCcom GLCommunicator ListServ