Post reply

change csv format, generated from xp_sendmail

  • March 4, 2002 at 10:44 am

    #101090

    In my xp_sendmail I create an attachment in csv format. When I open the file it looks like this:

    FirstName MiddleName LastName

    FirstName MiddleName LastName

    FirstName MiddleName LastName

    Is there any way to make it generated in the following format:

    FirstName

    MiddleName

    LastName

    FirstName

    MiddleName

    LastName

    FirstName

    MiddleName

    LastName

    Edited by - enya on 03/04/2002 11:10:39 AM

  • March 4, 2002 at 1:17 pm

    #424864

    The only thing I can think of is generate a single columns as

    select firstname + char(13) + middle + char(13)...

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply