I've generated a bunch of emails successfully from a Campaign Activity... all are created as activities with the status set to Draft. Using the Excel Online feature, I was able to update all the Follow & Email Reminder fields for the activities successfully.
However, when I try to set the Status Reason (that's currently Draft) to Pending Send, the bulk operation fails for each item in the spreadsheet with the following error:
state code is invalid or state code is valid but status code is invalid for specified state code
This isn't helpful as it doesn't indicate what I should pick, as the Excel Online workbook gave specific options to pick from.
From my research, all the results mention using the Bulk Edit option or Edit option in the toolbar, but neither exists on the Activities > All Draft Emails view.
Is it possible to send in bulk all these draft emails, or have them just sent when I Distribute the Campaign Activity?