{"id":4565,"date":"2013-08-31T06:18:45","date_gmt":"2013-08-31T06:18:45","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=4565"},"modified":"2013-08-31T06:18:45","modified_gmt":"2013-08-31T06:18:45","slug":"print-current-date-on-mail-merge-document-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/","title":{"rendered":"Print Current Date on Mail Merge Document in Sage CRM"},"content":{"rendered":"

In Sage CRM, Users can use an excellent feature of \u201cMail Merge\u201d, which is used to print Customer Details, Sales Order Details etc. In our previous blog, we explained how “Mail Merge can be done in Sage CRM<\/a>“. However, there was no way to print current date on the Template.
\nWell, it can be done by tweaking Sage CRM standard views, which are responsible for the mail merging. Let us explain it in detail;<\/p>\n

1.<\/strong> Navigate to Administration | Customization | Company.
\n2.<\/strong> Click on Views tab and select the vMailMergeCompany view.
\n3.<\/strong> Modify the view such that current date will be available in the view.<\/p>\n

For example, using below syntax you can print current date.
\n(VARCHAR(10),GETDATE(),101) as Currentdate<\/i><\/span><\/p>\n

Note: <\/i><\/b>You can use any format to print the date by changing above syntax. We have taken MM\/DD\/YYYY format.<\/i><\/p>\n

4.<\/strong> Click on Save<\/b> button to save the changes and refresh Metadata by navigating to Administration | System | Metadata.
\n5.<\/strong> Then, navigate to Customer summary, whose details need to be printed. Hence, click on Main Menu | New | Mail Merge option.<\/p>\n

The New Stuff:<\/strong><\/span>\u00a0Features of Outlook integration with SageCRM 7.2<\/a><\/em><\/p>\n

\"1.<\/a><\/p>\n

6.<\/strong> Select Customer Template which you want to print.<\/p>\n

\"2.<\/a><\/p>\n

7.<\/strong> You will be navigated to the Edit and Merge Document screen.<\/p>\n

\"3.<\/a><\/p>\n

8.<\/strong> To add current date, select currentdate field from Insert Sage CRM field drop-down and add it into template.<\/p>\n

\"4.<\/a><\/p>\n

9.<\/strong> Once selected, it will be added into the template. You can save template using Save Template<\/b> button.<\/p>\n

\"5.<\/a><\/p>\n

10.<\/strong> User can click on the Preview Merge or Merge and Continue <\/b>button, to get the current date on the customer details.<\/p>\n

\"6.<\/a><\/p>\n

By following above steps, Sage CRM user can easily print Current date on any template in a very easy and simplified manner.
\nAlso Read:<\/strong><\/p>\n

1.<\/strong>\u00a0Installing Outlook integration with SageCRM 7.2<\/a>
\n2.<\/strong>\u00a0Outlook integration \u2013 Limit on number of emails that can be filed<\/a>
\n3.<\/strong>\u00a0Adding Document Filing and Mail Merge functionality to Custom Entities<\/a>
\n4.<\/strong>\u00a0Put user first name in escalation emails in place of full name that comes by default<\/a>
\n5.<\/strong>\u00a0Extra information from Person entity while Mail merge<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage CRM, Users can use an excellent feature of \u201cMail Merge\u201d, which is used to print Customer Details, Sales Order Details etc. In our previous blog, we explained how “Mail Merge can be done in Sage CRM“. However, there was no way to print current date on the Template. Well, it can be done\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[332],"tags":[851,1552,1808,2010],"class_list":["post-4565","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-current-date","tag-mail-merge","tag-print","tag-sage-crm"],"yoast_head":"\nPrint Current Date on Mail Merge Document in 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\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Print Current Date on Mail Merge Document in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In Sage CRM, Users can use an excellent feature of \u201cMail Merge\u201d, which is used to print Customer Details, Sales Order Details etc. In our previous blog, we explained how “Mail Merge can be done in Sage CRM“. However, there was no way to print current date on the Template. Well, it can be done\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-31T06:18:45+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png\" \/>\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\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/\",\"name\":\"Print Current Date on Mail Merge Document in 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\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png\",\"datePublished\":\"2013-08-31T06:18:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Print Current Date on Mail Merge Document in 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":"Print Current Date on Mail Merge Document in 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\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Print Current Date on Mail Merge Document in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In Sage CRM, Users can use an excellent feature of \u201cMail Merge\u201d, which is used to print Customer Details, Sales Order Details etc. In our previous blog, we explained how “Mail Merge can be done in Sage CRM“. However, there was no way to print current date on the Template. Well, it can be done\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-08-31T06:18:45+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png","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\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/","name":"Print Current Date on Mail Merge Document in 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\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png","datePublished":"2013-08-31T06:18:45+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/08\/1.-Mail-Merge.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/08\/31\/print-current-date-on-mail-merge-document-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Print Current Date on Mail Merge Document in 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\/4565","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=4565"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/4565\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=4565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=4565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=4565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}