I’m getting the following error message:
System.Data.OleDb.OleDbException: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
This is a known bug that results from the software attempting to insert an email address into the “Campaign Results” table in the database, which records the result of sending an email, such as “Success,” Failure,” “BounceBack,” or “Unsubscribe.” The problem is that the field size in the database is too small (75 characters) to accept an email address which is over 75 characters long. This issue will be fixed in the upcoming release of Email Marketing Pro.
Workaround: Delete any email addresses that appear to be over 75 characters in length.
Workaround 2: If you are familiar with Microsoft Access, you can open the Email Marketing Pro database located in C:\Program Files\James River Software\Email Marketing Professional 2010 Small Business Version\DBPro.mdb. Build a query with the following statement and delete the result set:
SELECT Email
FROM Contacts
WHERE (((Len([Email]))>75));
