The most likely reason for a #VALUE result is that either or both'.rib' and 'SMTP:' are absent. Also happens if '.rib' comes before 'SMTP:'Does '.rib' come immediately after each email address?