Don’t worry if you don’t understand the meaning of these properties yet the code will be discussed soon in more detail. If you want to send the emails automatically without showing the composed email (like the demo above), you can uncomment the “send” property and comment out the “display” property in the VBA code. Notice that the emails don’t automatically send, and instead display the email contents for you to check before clicking send. In the demonstration above, you will see that two emails are created when you click the “Send Mass Email” button because there are only two contacts in the list. The “Send Mass Email” button will generate personalized emails to everyone in your list of contacts. Once you feel confident with the message format, click the second button, “Send Mass Email.” You can test if the email is in your desired format by clicking the first button, “Test Email Template,” which will display the email for the first contact only. The body of your email is formulated inside the input box (on the right). The program works by iterating through a list of contacts (columns A to F in this example) and generating an email for each contact. It’s best to get a high-level overview of the program before jumping into the code.
0 kommentar(er)
