plejazz.blogg.se

You can check them for errors before sending them out. Thunderbird will create the messages and place them in your outbox.

It’s probably a good idea to send the messages later. Set the “Source” to CSV, then browse for the CSV file that you saved from LibreOffice Calc. When you’re done writing your email, go to “File” in the email window and select “Mail Merge.”Ī window will open up. Make sure that the words inside the brackets match the column headings that you set up in the spreadsheet. They look something like this: “.” Everywhere that you want to plug in the information from your spreadsheet, place these variables. Start by writing your email the way you normally would.

When Thunderbird starts back up, you’ll be able to use the Mail Merge. Thunderbird will require a restart for the mail merge add-on to take effect. Search for “Mail Merge.” The name of the add-on is “Mail Merge.” It will probably be the top result. Click on “Add-ons.” On the left menu click “Extensions.” That window will have a search bar to the right of the screen. It’s the format that Thunderbird accepts. Open it and scroll down until you find “Text CSV(.csv).” Select that one. At the bottom-left you’ll find a drop-down menu with file format options. When you’re done, go to “File,” then “Save As.” A save window will open up. Then fill in the data below to match each column. Create column headings that will correspond to the variables that you’ll plug into your email. You can set up the spreadsheet like you would any other. Use the spreadsheet to organize specific personal details for each email, like recipient names and email addresses. LibreOffice Calc is an excellent spreadsheet program that you can use to easily organize the information for your messages. Before doing anything, you need to set up a spreadsheet with the information that you want to plug in to the mail merge.