SendMail2
Sends a mail. This Stored Procedure is used to handle aggregates.
Procedure-Specific Information
SendMail2 Stored Procedure is specifically made for handling the aggregates. User has to provide the whole json structure in order to execute this Stored Procedure.
For Example:
EXECUTE SendMail2 Personalizations = '[{"to": [{"email": "john_doe@example.com", "name": "John Doe"}, {"email": "julia_doe@example.com", "name": "Julia Doe"}], "cc": [{"email": "jane_doe@example.com", "name": "Jane Doe"}], "bcc": [{"email": "james_doe@example.com", "name": "Jim Doe"}]}, {"from": {"email": "sales@example.com", "name": "Example Sales Team"}, "to": [{"email": "janice_doe@example.com", "name": "Janice Doe"}], "bcc": [{"email": "jordan_doe@example.com", "name": "Jordan Doe"}]}]', FromEmail = 'orders@example.com', FromName = 'Example Order Confirmation', Subject = 'Test Subject', Content = '[{"type": "text/html", "value": "test value"}]', Categories = '["cake", "pie"]'
Input
| Name | Type | Required | Description |
| Personalizations | String | True | An array of messages and their metadata. Each object within personalizations can be thought of as an envelope - it defines who should receive an individual message and how that message should be handled. |
| FromEmail | String | True | The email address of the sender. |
| FromName | String | True | The name of the sender. |
| ReplyToEmail | String | False | The email address of the person to whom you are replying to. |
| ReplyToName | String | False | The name of the person to whom you are replying to. |
| Subject | String | True | The global or 'message level' subject of your email. |
| Content | String | True | An array where you can specify the content of your email. |
| Attachments | String | False | An array of objects where you can specify any attachments you want to include. |
| Categories | String | False | An array of category names for this message. Each category name may not exceed 255 characters. |
| SendAt | String | False | A unix timestamp allowing you to specify when you want your email to be delivered. |
| BatchId | String | False | An ID representing a batch of emails to be sent at the same time. |
| AsmGroupId | String | False | The unsubscribe group to associate with this email. |
| AsmGroupsToDisplay | String | False | An array containing the unsubscribe groups that you would like to be displayed on the unsubscribe preferences page. |
| IpPoolName | String | False | The IP Pool that you would like to send this email from. |
| MailSettingsByPassListManagementEnable | String | False | A collection of different mail settings that you can use to specify how you would like this email to be handled. Indicates if this setting is enabled. |
| MailSettingsFooterEnable | String | False | The default footer that you would like included on every email. Indicates if this setting is enabled. |
| MailSettingsSandboxModeEnable | String | False | Sandbox Mode allows you to send a test email to ensure that your request body is valid and formatted correctly. Indicates if this setting is enabled. |
| TrackingSettingsClickTrackingEnable | String | False | Allows you to track if a recipient clicked a link in your email. Indicates if this setting is enabled. |
| TrackingSettingsClickTrackingEnableText | String | False | Allows you to track if a recipient clicked a link in your email. Indicates if this setting should be included in the text/plain portion of your email. |
| TrackingSettingsOpenTrackingEnable | String | False | Allows you to track if the email was opened by including a single pixel image in the body of the content. When the pixel is loaded, Twilio SendGrid can log that the email was opened. Indicates if this setting is enabled. |
| TrackingSettingsOpenTrackingSubstitutionTag | String | False | Allows you to track if the email was opened by including a single pixel image in the body of the content. When the pixel is loaded, Twilio SendGrid can log that the email was opened. Allows you to specify a substitution tag that you can insert in the body of your email at a location that you desire. This tag will be replaced by the open tracking pixel. |
| TrackingSettingsSubscriptionTrackingEnable | String | False | Allows you to insert a subscription management link at the bottom of the text and HTML bodies of your email. Indicates if this setting is enabled. |
Result Set Columns
| Name | Type | Description |
| Success | String | Whether or not the mail was sent successfully. |