Are you sure it gives you the same error when using , instead of ; ? Because your error is telling you that the semicon is not accepted. Would be weird is you get the same error using , instead of ;.
Please post the error when using a , as seperator. Also the error is pointing you the the exact character that is giving this error( position 21). Beacause you did change the data, can you please see what character it is?
Kirti,
I just looked at this in one of my apps which uses a comma as a separator.
Mike
My answer is coming probably too late but for those who run against this issue in the future. It's not only your ‘TO’ that needs to have comma as a seperator but also the ‘BCC’ and the ‘CC’ parts.
If you get this error, you have most likely used semicolon in one of these three fields as your seperator and that's causing the issue.