When I send emails, if the field containing the email address has a space at the beginning or end of the address it is ignored and not sent although the only way to discover this is to check sent items in my email package. Is it possible to prevent this from happening? I email a lot from the database and it is very inconvenient.

Cheers

Nick

PS I am using Microsoft Outlook to send the mails

I'm not sure if this help, but have you tried to trim the address?

i.e. email_add = alltrim(email_add)

-jimi