Can I Customise List Postings when the list members are held in a database?

  1. Home
  2. Knowledge Base
  3. GMS
  4. Can I Customise List Postings when the list members are held in a database?

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>
EMAIL2> Hi user,
EMAIL2>
EMAIL2> Please click on this URL:
EMAIL2> http://mysite.dom/page1/item.htm?id=iei&x=3
EMAIL2>

Keywords:Customise MML List Database ODBC Access GLCcom GLCommunicator ListServ

Was this article helpful?

Related Articles