If this is your first time using Mailmeteor in Sheets, the Receive a test email option in Preview emails won’t work. Before you try to create a real campaign, you should create a test mailmerge that sends an email to yourself and send the email without previewing it. This will cause Google to prompt you to authorize Mailmeter to act on behalf of your account. After completing this step, sending test emails to yourself will work as expected.