Using xp_sendmail

Results 1 to 2 of 2

Thread: Using xp_sendmail

  1. #1
    Join Date
    Dec 1969

    Default Using xp_sendmail

    I am wanting to use xp_sendmail to automate part of an sql database so when a user logs a call the system emails them a confirmation. I need to convert the name they put in into, but the name is in a single namefield. Any ideas appreciated!<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Using xp_sendmail

    Article on using xp_sendmail here:<BR><BR><BR>As for splitting the firstname & lastname, bad design. Seriously though, are they separated by a character, like a space? R&D CHARINDEX & SUBSTRING.<BR>HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts