Can I use Gmail to send my speaker links?
Yes you can, just follow these steps.
- Download the csv file of your speakers and their links from Gleanin. You will need to have already uploaded their email addresses.
- Import the csv file into Google Sheets.
- If you want to personalise the email you will need to split the name column into first name and last name columns. To do this,
- Add several columns to the right of the name column (you need several columns to allow for people with several names.)
- Click to highlight the name column
- Select the Data menu and then Split Text To Columns
- Choose Space as the separator
- Remove any of the columns you created that you don't need (you will see which columns are empty by scrolling down the sheet
- Name the headers of each column as follows:
- Column A:
- Column B:
- Column C:
- Column D:
- Column E:
- In the spreadsheet, click on custom menu item Mail Merge > Send Emails.