![]() These instructions tell how to use the third-party GoogleĪpps add-on Yet Another Mail Merge to do mail merge using aīDrive spreadsheet and the bMail web client. ![]() Mail merge available through bMail has a limit on the number of messagesįor the free version so we advise that you do not use it at this time. In the pull-down menu next to "Format," select text/plainĬlick "OK" and close the "Add-ons" windows. Pull down your "Tools" menu and select Add-onsĬlick the "Extensions" tab and then the "Options" button under Mail Merge. To avoid this problem, before you draft your message: * If you draft your message in plain text (rather than html), you may end up with a number of blank spaces at the beginning of your message. The mail merge add-on has online documentation if you'd like more detailed information. When you are ready to post them, pull down the "File" menu and select "Send When you open a message you should see the fields from the spreadsheet filled out.* Still in Thunderbird, look under "Local Folders"and you should seeĪ folder called "Outbox" ere with some new messages in it (one for each email address on your spreadsheet). Then click "Ok." (Using the example above, the dialog box should look something like thisĬlick "OK." The message should disappear. Text Delimiter dropdown, select the double quote("). In the Field Delimiter dropdown, select the single quote('). In the CSV section, click "Browse" and find your. Pull down the "File" menu and select "Mail Merge."Ī dialog box should pop up. Using the example spreadsheet created above, you message would resemble Parts of the spreadsheet that you would like to include in 2 sets curly braces. ĭraft the body of the message, enclosing the column headings for any To include in your message must be enclosed in 2 sets of curly braces. Any parts of the spreadsheet that you would like (If you closed Excel and viewed this file in a text editor, it would look like Save the spreadsheet as "CSV UTF-8 (Comma delimited)(*.csv)" ( see snapshot of drop down options) (The file should look something like this Make sure there is a header row with names for all columns these names must not contain spaces. Now the extension is set, and you can send a mail merge messageĬreate an Excel spreadsheet with the data you want in the message, including the full e-mail address. Pane, click "Restart Now" (next to "Mail Merge")
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |