Send Emails on Behalf of
How do I send emails on behalf of someone else?
APPLICATION: You want to send emails on behalf of your boss or someone else in your organization.
Refresh the add-on and select your recently added alias email address:
In the Google Docs Mail Merge sidebar, click Show Email Settings and select your alias email address from the From Email Account drop-down.
In the Google Sheets Mail Merge dialog box, select your alias email address from the From Email Account drop-down.
NOTE: The From Email Account drop-down will only appear in Google Docs if you have already added an alias email account (Step 1).
Advanced Feature: Send Emails Over SMTP
From the Google Docs Add-on Only
APPLICATION: Overcome limits by Gmail....
The Send mail as feature described above will not allow you to send emails over SMTP using your own account or other accounts within your Google Workspace domain. Therefore, if you want to use a third-party email provider, such as SendGrid, to send emails over SMTP with your Gmail account, you will need to set the provider's SMTP settings.
Click Add-ons > Mail Merge > SMTP Settings.
Select Yes from the drop-down and enter the SMTP authentication settings from your chosen email providor.
Click Save to apply changes.