Thank you, Thank you, Thank you - for your detailed tutorial. I was despairing of ever being able to send emails using a template without manually sending them individually to my list of about 40 newsletter subscribers using a Theme for each week. This would have been incredibly tedious, as I would have had to repeat the process every week. It would have created the potential for many errors, as well. Also, I appreciate you going through items such as "correcting" zip codes starting with the 0 numeral, synchronizing the fields. etc.
Thanks for making this video as a response to my request. I finally got to watch it. Sadly the way you presented it makes me confused as to how to print only the YES labeled Excel rows on a Envelope without it being so incredibly time consuming as it is shown from this video. The way you shown it makes it not worth it because there are so many steps until I can just reach the printing stage. I basically just want to choose in the Excel table the rows that will need printing by pasting a YES label besides every Address row ...... OR having a checkmark that I can just check by pressing one click. After finishing pasting only for the Addresses I actually need just press a button or press a keyboard key combination and just have the printing starting, printing each different YES labeled address on a Envelope that is already formatted and layout on the Envelope is already set up to just fill in the addresses from the Excel table. How do i do that? Thank you again!
Thanks for asking a question and watching the video! I would recommend finding out how your email client (such as Gmail and Outlook) or email marketing service (like Mailchimp and AWeber) can handle mail merge with attachments. LibreOffice Calc and Writer can help you create attachments and separate email messages by using Mail Merge. However, it cannot actually send the emails.