October 2, 2002 at 7:09 am
I am trying to use xp_sendmail to send to an x400 address. The problem is that the address is in the format '[X400:c=GB;a= ;p=SOMEWHERE;o=...etc]', which Exchange Client understands, but SQL Mail ignores the enclosing square brackets and treats ';' as a seperator between addresses.
Does anyone know of a way I can express the address so that SQL Mail understands it?
October 2, 2002 at 7:26 am
Rather than using xp_sendmail, perhaps you should look at using CDO - Collaboration Data Objects. These offer a much richer interface, which I believe includes X400 addressing.
October 2, 2002 at 7:26 am
If it's only a handful of addresses which should be used a lot, you always have the option of adding a Personal Address Book (PAB) or Outlook Contacts and telling the MAPI profile to look there first when trying to resolve names. Then, in xp_sendmail you use the name found in your PAB.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply