{"id":746,"date":"2023-08-05T10:47:46","date_gmt":"2023-08-05T10:47:46","guid":{"rendered":"https:\/\/dalesdemo.xyz\/?post_type=projects&#038;p=746"},"modified":"2023-08-05T11:05:31","modified_gmt":"2023-08-05T11:05:31","slug":"outlook-template-engine-vba","status":"publish","type":"projects","link":"https:\/\/dalesdemo.xyz\/index.php\/projects\/outlook-template-engine-vba\/","title":{"rendered":"Outlook Template Engine (VBA)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"746\" class=\"elementor elementor-746\" data-elementor-post-type=\"projects\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bac1f03 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bac1f03\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-03513a6\" data-id=\"03513a6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9cf08cf elementor-widget elementor-widget-image\" data-id=\"9cf08cf\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.23.0 - 05-08-2024 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"489\" height=\"373\" src=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateengine.png\" class=\"attachment-large size-large wp-image-747\" alt=\"\" srcset=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateengine.png 489w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateengine-300x229.png 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-69e6720\" data-id=\"69e6720\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a3761aa elementor-widget elementor-widget-heading\" data-id=\"a3761aa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.23.0 - 05-08-2024 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">What is it?<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2c247b elementor-widget elementor-widget-text-editor\" data-id=\"e2c247b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.23.0 - 05-08-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>A need arouse at my partners business to send regular templates to customers with varying fields. I could have manually programmed all of these templates however I decided to build an engine that could grow with them and allow them to add their own templates.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0a8044b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a8044b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-d6d3eed\" data-id=\"d6d3eed\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-292394e elementor-widget elementor-widget-heading\" data-id=\"292394e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">User journey<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d6af3b4 elementor-align-left elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"d6af3b4\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/dalesdemo.xyz\/wp-content\/plugins\/elementor\/assets\/css\/widget-icon-list.min.css\">\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-play-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">User starts marco<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-list-alt\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">User selects template to use<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-pencil-alt\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">User fills in inputs<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-envelope-open-text\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Email Generated with %var% replaced<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6afc811\" data-id=\"6afc811\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c4764e9 elementor-widget elementor-widget-heading\" data-id=\"c4764e9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">New template journey<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba80656 elementor-align-left elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"ba80656\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-mail-bulk\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">User created a new template in outlook<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-arrows-alt\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">User makes variables in email inside % such as %firstname%<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-pencil-alt\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">User saves template and adds a .txt files with settings<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-stop-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Finished<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2f2b953 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f2b953\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-ad18696\" data-id=\"ad18696\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-07dfab5 elementor-widget elementor-widget-heading\" data-id=\"07dfab5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Inside template outlook<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-738bb93 elementor-widget elementor-widget-image\" data-id=\"738bb93\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateoutlook.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"templateoutlook\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NzU4LCJ1cmwiOiJodHRwczpcL1wvZGFsZXNkZW1vLnh5elwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyM1wvMDhcL3RlbXBsYXRlb3V0bG9vay5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"296\" src=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateoutlook-1024x379.png\" class=\"attachment-large size-large wp-image-758\" alt=\"\" srcset=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateoutlook-1024x379.png 1024w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateoutlook-300x111.png 300w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateoutlook-768x284.png 768w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateoutlook-1536x568.png 1536w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateoutlook.png 1953w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-574693a\" data-id=\"574693a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fff0d3d elementor-widget elementor-widget-heading\" data-id=\"fff0d3d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">File structure<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-434a45d elementor-widget elementor-widget-image\" data-id=\"434a45d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/template-fileinfo.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"template fileinfo\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NzU3LCJ1cmwiOiJodHRwczpcL1wvZGFsZXNkZW1vLnh5elwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyM1wvMDhcL3RlbXBsYXRlLWZpbGVpbmZvLnBuZyJ9\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"795\" height=\"197\" src=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/template-fileinfo.png\" class=\"attachment-large size-large wp-image-757\" alt=\"\" srcset=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/template-fileinfo.png 795w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/template-fileinfo-300x74.png 300w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/template-fileinfo-768x190.png 768w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-f3ae9bf\" data-id=\"f3ae9bf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3c42a90 elementor-widget elementor-widget-heading\" data-id=\"3c42a90\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Prompt example<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a0cb56 elementor-widget elementor-widget-image\" data-id=\"7a0cb56\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"476\" src=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/prompts.png\" class=\"attachment-large size-large wp-image-759\" alt=\"\" srcset=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/prompts.png 804w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/prompts-300x178.png 300w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/prompts-768x457.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-26ba670 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"26ba670\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-c0b32ab\" data-id=\"c0b32ab\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-325f23a elementor-widget elementor-widget-image\" data-id=\"325f23a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"489\" height=\"373\" src=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateengine.png\" class=\"attachment-large size-large wp-image-747\" alt=\"\" srcset=\"https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateengine.png 489w, https:\/\/dalesdemo.xyz\/wp-content\/uploads\/2023\/08\/templateengine-300x229.png 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-cd2f567\" data-id=\"cd2f567\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a633ccb elementor-widget elementor-widget-heading\" data-id=\"a633ccb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How does it work?<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35996cb elementor-widget elementor-widget-text-editor\" data-id=\"35996cb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>On launch the vba module scans folder C:\\temp\\emailtemplate\\ for all &#8220;.oft&#8221; files and presents them in a list to the user. When a list clicks on the list we use the list_click to search the templatefolder for the .txt document, inside of this is the templates human-readable name and various details such as toemail(to &#8211; email not toe mail). When the user clicks &#8220;launch template&#8221; the code scans the oft file and pulls out any %variable% inside for example &#8220;Dear %firstname%&#8221; it will add this to a list of questions to ask the user.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4bd734d elementor-widget elementor-widget-text-editor\" data-id=\"4bd734d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The user is then shown prompts to fill out, which will replace those variables in the email. by using this method of counting the % we allow users to create a template with an unlimited amount of variables and do not create artificial limits.<\/p><p>After the user completes all of these inputs the code runs that against mail.htmlbody using the VBA &#8220;replace&#8221; command.\u00a0<br \/><br \/>Then this is shown to the user as a email using this command which saves to drafts then displays the email.<br \/>NewMail.Close olSave &#8216;drafts<br \/>NewMail.Display<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>A template engine that pulls outlook templates and replaces values with prompts from VBA<\/p>\n","protected":false},"featured_media":747,"template":"","meta":{"_acf_changed":false},"categories":[12,17,23,13],"tags":[],"class_list":["post-746","projects","type-projects","status-publish","has-post-thumbnail","hentry","category-programming","category-script","category-visual-basic","category-vb6"],"acf":[],"_links":{"self":[{"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/projects\/746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/projects"}],"about":[{"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/types\/projects"}],"version-history":[{"count":5,"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/projects\/746\/revisions"}],"predecessor-version":[{"id":762,"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/projects\/746\/revisions\/762"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/media\/747"}],"wp:attachment":[{"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dalesdemo.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}