{"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
How to Send a HTML Email using Word Email Template using Excel Macro<\/h1>\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
Things Needed:<\/h2>\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
How to Do:<\/h2>\n
Creating Word Template:<\/h3>\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
\n\n
\n
\n
Template as Needed<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n
Hi All,<\/span> <\/p>\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
<\/span><\/p>\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
\n\n
\n
\n
Email as Needed<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n
Hi All,<\/span> <\/p>\n
Please find the below status about Marks secured by candidates of XII<\/strong> Standard, during Quarterly<\/strong> Examinations.<\/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