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)
 SQL Mail - xp_readmail - attachment value?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-08 : 11:57:05
Jeyakumar writes "Hi,

I'm working on some stuff like,

1) Receiving mails to SQL mail box
2) findout the attachment
3) upload in to table.

I'm using xp_readmail objects, but I didn't find much info. about readmail in microsoft/sql site.

I like to know, how to get the attachment file name from the xp_readmail-result set to a variable. So that I can use that file name in Bulk Insert to upload the data into a table.

Any idea?"
   

- Advertisement -