It can happen that YAMM menu doesn't load properly, or that some entries are missing. This is just a temporary issue and in general it is automatically fixed within a few seconds.
Only 'Help' is displayed in the add-on menu
If you can only see 'Help' under Add-ons > Yet Another Mail Merge, it is usually an issue related to Google Sheets:
Simply refresh your spreadsheet, wait a few seconds, then try YAMM again.
The 'Open tracking report' button doesn't appear
When you open a spreadsheet that has been shared to you, you might see 'Configure form submission notifications' instead of 'Open tracking report':
This is because YAMM is not activated in this Google Sheets yet. To do so, click 'Add-ons' > 'Manage add-ons...'. Then next to YAMM, click the green button 'Manage' and select 'Use in this document':
Close this pop-up, refresh your spreadsheet and you should see 'Open tracking report' again:
The 'Add-ons' menu doesn't appear on my spreadsheet
When you open your Google Spreadsheet, the 'Add-ons' menu doesn't exist so you can't send a mail merge. This is because you probably used an Excel file as original spreadsheet.
If so, a green '.XLSX' information at the top of your speadsheet appears:
In order to see the 'Add-ons' tab, you have two possibilities:
- Use a Google Spreadsheet as original file
- Import your data from your Excel file to a new Google Spreadsheet
To import your data, open a new Google Spreadsheet from your Excel original file.
To do so, click 'File' > 'New' > 'Spreadsheet':
Then, click 'File' > 'Import':
A pop-up appears. In our example, we decided to select 'Replace spreadsheet' so the data are imported in the spreadsheet we've just created.
Then, click 'Import data':
That's it! Your data has been imported on your new Google Spreadsheet. You are now able to see the 'Add-ons' tab and send a Mail Merge: