Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How I do to get always a e-mail address using xp_readmail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-22 : 07:36:48
Ennio writes "Sorry for my English.

I use xp_readmail for read e-mail from SQL Server e-mail address.
I've need to get always a e-mail address of recipient instead of name (using @recipients of xp_readmail); in fact, if sender mail have insert recipient into his address book I find the name in @recipients, not e-mail address.

For example:

This is @recipients of e-mail with tree recipients; two are names and one is e-mail address.

administrator; Ennio Folio; 'enniofol@tin.it'


Can you help my ?

Thanks, Ennio"
   

- Advertisement -