mwlyoung
SSC Rookie
Points: 38
More actions
April 22, 2003 at 5:01 am
#80602
Hi there
Is there any way that I can send the result set of xp_sendmail in an excel readable format such as csv rather than a text file?
TIA
Reach for the stars, not the ceiling...
Steve Jones - SSC Editor
SSC Guru
Points: 734459
April 22, 2003 at 10:12 am
#454927
You can use DTS to export the data and xp_sendmail or the mail task to then mail it.
Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones
http://www.dkranch.net
April 23, 2003 at 1:34 am
#454994
Thanks for your help.
It works wonderfully now.
Cheers
Louis
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply