When sending an appeal mailing via email, the appeal runs and completes, but the email job may fail and produce the following error:
Invalid object name 'MKTSEGMENTATIONEXPORT_XXXX'. Could not use view or function 'dbo.V_MKTSEGMENTATIONEXPORT_XXXX' because of binding errors.
This error can occur because the mailing was deleted before the email job was completed. The email process is unable to complete the job due to the mailing being deleted. Please copy the mailing and resend it.
1. Copy the mailing
- Go to Marketing and Communications > Appeal Mailings - Select the dropdown arrow next to the mailing, click Copy
2. Run the copy of the mailing
- Hit the run mailing button from inside of the appeal
3. Go to Administration > Email Services > Email jobs and verify the job is running