{"id":10972,"date":"2015-09-19T11:08:01","date_gmt":"2015-09-19T11:08:01","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=10972"},"modified":"2015-09-19T11:08:01","modified_gmt":"2015-09-19T11:08:01","slug":"send-auto-festival-greetings-through-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/","title":{"rendered":"Send Auto – Festival Greetings through Sage CRM"},"content":{"rendered":"

In Sage CRM<\/a>, Timings functionality has helped to track the duration of any entity record right from the time it is opened till it gets closed. For a more accurate measurement of duration, this information can be combined with a Business Calendar, which defines standard business days and work times along with Holiday Sets for different regions. But have you thought of making use of such awesome functionality for Client interaction rather than only internal usage??<\/p>\n

New Stuff:\u00a0<\/em><\/span><\/strong>Interactive Dashboard refuses to work? This could be related to SQL Server Configuration error<\/a><\/span><\/span><\/p>\n

In below article I will explain you one of the valuable feature which will help the Business Organization to improvise client collaboration with few easy configurations. The Holiday Set of Sage CRM<\/a> enables the user to create a Holiday list with the help of Holiday Name & Date. These details are thereby stored in a table named \u2018HolidaySetItems<\/em><\/strong>\u2018. With the help of some views and Escalation rules as explained below, you will be able to send Festival Greetings to you Client\/Customer.<\/p>\n

1.<\/strong> Create a Holiday list in CRM under Holiday Set<\/strong> tab by navigating to Administration |\u00a0System |\u00a0Timings<\/strong> path.
\n2.<\/strong> Create a view under Views<\/strong> tab by navigating to Administration\u00a0|\u00a0Customization |\u00a0Person<\/strong> in order to get those person or company records whom you wish to send greeting mails.
\n3.<\/strong> Create a Escalation Rule by navigating to Administration |\u00a0Advanced Customization |\u00a0Escalation<\/strong>.
\n4.<\/strong> Mention below given Trigger Clause<\/strong> and Save
\nCONVERT (DATE, HSIt_HolidayDate) =CONVERT (DATE, GETDATE ()) and HSIt_Deleted is null<\/em>
\n5.<\/strong> Add Send Email<\/strong> action to this rule.<\/p>\n

\u00a0\"image1\"<\/a><\/p>\n

6.<\/strong> Accordingly configure the Email Template<\/strong> & Save.<\/p>\n

\"image2\"<\/a><\/p>\n

Once done, you are ready to send the festival greetings to your clients. However, you need to avoid\/handle sending these emails multiple times to single customer within a day. To do the same, maintain a flag against\u00a0the Person\/Customer table and update it as ‘Y’<\/strong> \u00a0once the mail sending is completed for those records found under the view created in Step no # 2.<\/p>\n

7.<\/strong> Click on New<\/strong> button.
\n8<\/strong>. Select Execute SQL statement<\/strong> and mention the flag update clause.<\/p>\n

\"image3\"<\/a>
\n9.<\/strong> Set Order<\/strong> as 9999<\/strong>.
\n10.<\/strong> Set Show Confirmation Message<\/strong> as \u2018Yes<\/strong>\u2019 and Save.<\/p>\n

Also Read –\u00a0<\/span><\/strong><\/em><\/p>\n

1. Date Calculation considering Federal Holidays<\/a>.
\n2. Calculating dates excluding Saturdays and Sundays<\/a>
\n3. Escalation Rules<\/a>
\n4. Set Birthday reminders in Sage CRM<\/a>
\n5. Sending Emails to multiple Persons<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage CRM, Timings functionality has helped to track the duration of any entity record right from the time it is opened till it gets closed. For a more accurate measurement of duration, this information can be combined with a Business Calendar, which defines standard business days and work times along with Holiday Sets for\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65,73,97,131,140,285,332,1,423,424],"tags":[1136,1207,1352,1353,1354,2445],"class_list":["post-10972","post","type-post","status-publish","format-standard","hentry","category-codeless","category-configuration","category-customer","category-email","category-escalations","category-person","category-sage-crm","category-uncategorized","category-view","category-views","tag-festival-greetings","tag-greetings-mails","tag-holiday","tag-holiday-list","tag-holiday-set","tag-timings"],"yoast_head":"\nSend Auto - Festival Greetings through Sage CRM - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Send Auto - Festival Greetings through Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In Sage CRM, Timings functionality has helped to track the duration of any entity record right from the time it is opened till it gets closed. For a more accurate measurement of duration, this information can be combined with a Business Calendar, which defines standard business days and work times along with Holiday Sets for\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-19T11:08:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/\",\"name\":\"Send Auto - Festival Greetings through Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg\",\"datePublished\":\"2015-09-19T11:08:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Send Auto – Festival Greetings through Sage CRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Send Auto - Festival Greetings through Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Send Auto - Festival Greetings through Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In Sage CRM, Timings functionality has helped to track the duration of any entity record right from the time it is opened till it gets closed. For a more accurate measurement of duration, this information can be combined with a Business Calendar, which defines standard business days and work times along with Holiday Sets for\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-09-19T11:08:01+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/","name":"Send Auto - Festival Greetings through Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg","datePublished":"2015-09-19T11:08:01+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/09\/image11.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/09\/19\/send-auto-festival-greetings-through-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Send Auto – Festival Greetings through Sage CRM"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/10972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=10972"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/10972\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=10972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=10972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=10972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}