{"id":12170,"date":"2012-12-17T10:15:17","date_gmt":"2012-12-17T10:15:17","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2636"},"modified":"2022-08-12T11:31:53","modified_gmt":"2022-08-12T11:31:53","slug":"sending-a-html-email-using-word-email-template-and-excel-macros","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/12\/sending-a-html-email-using-word-email-template-and-excel-macros\/","title":{"rendered":"Sending a HTML Email using Word Email Template and Excel Macros"},"content":{"rendered":"
<\/p>\n
Hi All,<\/p>\n
<\/p>\n
This is my very first post for learnexcelmacro.com. Thanks to Vishwa for roping me in for this good cause.<\/p>\n
Your Help\/ comments \/ suggestions for improving this better.<\/p>\n
1. Word Document that can serve as a template, with field maps<\/em> and bookmarks<\/em> that can help us in getting our custom Data<\/p>\n 2. Excel Macro that can have this Word Document as an object and which has details that needs to be pasted \/ brought in the Template, to form a custom mailer.<\/p>\n 1. Open an Empty Word Document and type your message as needed. For Example, following is my template message. I would append and insert text and Tables later using Excel macros in places as needed.<\/p>\n Template as Needed<\/strong><\/p>\n<\/td>\n<\/tr>\n Please find the below status about Marks secured by candidates of \u00a0Standard, during \u00a0Examinations.<\/span><\/p>\n <\/p>\n Thanks and Regards,<\/strong><\/span><\/p>\n Management Team \u2013 XXX School<\/strong><\/span><\/p>\n P.S: This is an Auto Generated Email. You are receiving this email, since you are part of the Parent Teachers Association for this Year.<\/span><\/p>\n Please help us improving the quality of this process, through your Inputs and suggestions.<\/span><\/p>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u00a02. Now Insert Bookmarks<\/em> and then field maps<\/em> in places, where you need custom input text from Excel Macro. For Example, in the Above mentioned template, I would like to get the Standard Name, Examination name<\/strong> and the Result Table<\/strong>, so\u00a0 that the Email looks something like below.<\/p>\n <\/p>\n Email as Needed<\/strong><\/p>\n<\/td>\n<\/tr>\n Please find the below status about Marks secured by candidates of XII<\/strong> Standard, during Quarterly<\/strong> Examinations.<\/span><\/p>\n <\/p>\n <\/p>\n <\/p>\n Thanks and Regards,<\/strong><\/span><\/p>\n Management Team, XXX School.<\/strong><\/span><\/p>\n P.S: This is an Auto Generated Email. You are receiving this email, since you are part of the Parent Teachers Association for this Year.<\/span><\/p>\n Please help us improving the quality of this process, through your Inputs and suggestions.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u00a03. Follow the Below Instructions to insert a bookmark.<\/p>\n a. Place the cursor at the position intended to create a bookmark.<\/p>\n b.\u00a0 Go To \u201cInsert\u201d Tab and Hit \u201cBookmark\u201d.<\/p>\n <\/p>\nHow to Do:<\/h2>\n
Creating Word Template:<\/h3>\n
\n\n
\n \n \n Hi All,<\/span> <\/p>\n
<\/span><\/p>\n\n\n
\n \n \n Hi All,<\/span> <\/p>\n \n\n
\n S.No<\/strong><\/td>\n Student Name<\/strong><\/td>\n Register No<\/strong><\/td>\n Mark 1<\/strong><\/td>\n Mark 2<\/strong><\/td>\n Total<\/strong><\/td>\n Status<\/strong><\/td>\n<\/tr>\n \n 1<\/td>\n Name 1<\/td>\n XXYYYZZ01<\/td>\n 60<\/td>\n 60<\/td>\n 120<\/td>\n PASS<\/td>\n<\/tr>\n \n 2<\/td>\n Name 2<\/td>\n XXYYYZZ02<\/td>\n 40<\/td>\n 60<\/td>\n 100<\/td>\n FAIL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n